SUM IF

[bansefi01]

I have the following table

RECLAMADA	IMP_APNTE
#N/A	142536
124578963	300
#N/A	5000
35489785235	152456
548795423356	30065

I need to add ONLY those values with RECLAMADA field different than #N/A

I'm trying with this formula but the outcome is ZERO.. any ideas ?

If(RECLAMADA = '#N/A', 1, Sum(IMP_APNTE))

thanks

[luismadriz]

Hi,

please try this one as the measure

Sum({<RECLAMADA -= {"#N/A"}>} IMP_APNTE)

And only leave RECLAMADA as the dimension,

I hope this helps

Saludos

Luis

[bansefi01]

Thanks, I´ll try it, Is for a KPI

[devarasu07]

Hi,

yes u can apply this set expression in both object (kpi , stright table etc). refer to the sample attached

[luismadriz]

Hi Fernando,

When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

Cheers,

Luis