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
 
					
				
		
 MarcoWedel
		
			MarcoWedel
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		you're welcome
regards
Marco
