Pivot calculation showing as “-“ rather than “0%”

[mohiahmed]

I need help on a pivot calculation please. Used a simple sum to show % if few area by month. However when the calculation should be at “0%” it’s showing me “-“. I changed missing symbols in presentation tab to 0% and it shows me correctly where I have a value. Also at times there will be null values to calculate that also showing “0%”which is incorrect. Help will be greatly appreciated thanks.

[kaushiknsolanki]

Hi,

Try this.

Num(Alt(Expression, 0), '#,##0.00%')

Regards,

Kaushik Solanki

[mohiahmed]

Thank you Kaushik, however I am still getting “-“ in my results after updating the expression. I have attached the expression. Also, do I need to make any changes to presentation tab?