Sum if expression

[#1]

hi All

Could you please confirm whether the below given expression is accurate

sum(If(Sales='0',Planned,Sales))

Month     Sales,   Planned

Jun           100       100

Jul             150         100

Aug             0            200

Based on above sample data, i would like to calculate  cumulative sales  for  3 months

Sum  all sales but if sales is equal to zero , then planned value should be aggregated

Thus , total value for three months should 100+150+200 = 450

BR

Jayanthan

[#2]

Hi Macro

Yeah, i was looking IsNull .Thank You

BR

Jayanthan

[MarcoWedel]

you're welcome

regards

Marco