How and where to use IF condition

[#1]

Hi,

I like to know about the usage of if condition within data...

can any one help where to place the condition if i want to use that in pivot table.

[#2]

hi

you can use if condition in any expressions

zaman

[#3]

ProductName	Sum (CountingUnits)	Sum ({$1}CountingUnits)
AGX	0.00	20880.00
AS	10604950.00	10604950.00
COGRELH	0.00	57540.00
CLO	0.00	1110.00
CO	0.00	2071520.00
GS	0.00	130830.00
ITOR	0.00	1157500.00
PETIN	0.00	529700.00
PVIX	0.00	807184.00
TAAL	0.00	680800.00
TRO	0.00	174100.00

can you tell how to use if condition to show only the values >0.00 in an expression

[#4]

hi

write this

if(Sum(CountingUnits)>0,Sum(CountingUnits))

thank

zaman