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.
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?
