Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning All,
In a pivot table dimention is Sales Person and the expression is
=Sum(if(Aged='2/1-30 DAYS',[Value])) +Sum(if(Aged='3/31-60 DAYS',[Value]))+Sum(if(Aged='4/61-90 DAYS',[Value]))+Sum(if(Aged='5/90+DAYS',[Value])),
its working fine if the Sales Person has some values suppose if the Sales Person has no value means, I would like to display 0 or 'No Value'.
I have tried the following expression but it says error in the expression can anybody help me how to resolve this.
=If(Sum(if(Aged='2/1-30 DAYS',[Euro])) +Sum(if(Aged='3/31-60 DAYS',[Euro]))+Sum(if(Aged='4/61-90 DAYS',[Euro]))+Sum(if(Aged='5/90+DAYS',[Euro])),0,0,(Sum(if(Aged='2/1-30 DAYS',[Euro])) +Sum(if(Aged='3/31-60 DAYS',[Euro]))+Sum(if(Aged='4/61-90 DAYS',[Euro]))+Sum(if(Aged='5/90+DAYS',[Euro]))))
Regards
HI,
Try this expression and setting said below.
Expression
sum({<Aged = {'2/1-30 DAYS','3/31-60 DAYS','4/61-90 DAYS','5/90+DAYS'}>}EURO)
Now go to presentation tab and deselect "Supress Zero Values".
Hope this will solve your problem.
Regards,
Kaushik Solanki
HI,
Try this expression and setting said below.
Expression
sum({<Aged = {'2/1-30 DAYS','3/31-60 DAYS','4/61-90 DAYS','5/90+DAYS'}>}EURO)
Now go to presentation tab and deselect "Supress Zero Values".
Hope this will solve your problem.
Regards,
Kaushik Solanki
Dear Kaushik,
thanks for your help, its working fine.....
Regards
Chriss Mervin