Need help in writing the Expression

[#1]

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

Chriss Mervin

[kaushiknsolanki · Accepted solution]

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

[#3]

Dear Kaushik,

thanks for your help, its working fine.....

Regards

Chriss Mervin