Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Macro
Yeah, i was looking IsNull .Thank You
BR
Jayanthan
you're welcome
regards
Marco