IF function

[Anonymous]

ID	Amount
AAA	10
BBB	0
CCC	3
DDD	0

I would simply want to sum amount with value (not zero) so i use  SUM(IF(Amount > 0, Amount)) but it turns out wrong.Alternatively want to display only ID's with Amount.

Thanks

Kwame

[tresesco]

PFA

[CELAMBARASAN]

Try with this

Sum({<Amount={"<>0"}>} Amount)

Which type of chart you are using?

[Anonymous]

Preferably a pivot table

[er_mohit]

simply try add ID in Dimension

and write expression Sum(Amount)

it gives you the data without zero but make sure that in presentation tab  check on suppress zero values

and if there's other column having data and you want to supress this row where Amount zero then use that column like if it is your 1st column then try to put condition in 2nd column for that partiular field in this way

if(Column(1)=0,0,condition for other column then it automatically supres that row

hope it helps