Table with Value 0 is shown as "-"

[peisenrot]

Hello,

I have a Pivot table were in one cell the calculated value is Zero. That is right but the user would like to see the "0" and not the "-" as it is shown. What do I have to do except make a if-clause.

Please help.

Best regards

Pia

[MayilVahanan]

Might be, try with Alt() function

Alt(urExpr, 0)

[peisenrot]

hello Mayil, 

thanks for the idea. unfortunately it didn't work because the it is 

Alt(NRE,0) / pow(10,6) and Alt(NRE / pow(10,6),0) show the no calculation possibility when NRE is zero

do you have an idea what to do?

Best regards

Pia

[MayilVahanan · Accepted solution]

Hi

If NRE is zero, then 0 divide by anything is zero. 

So I think its not the case. Might be, there is no NRE values for those dimensions.