Display 0% for Null

[Anonymous]

Hello.

I am currently making a market share chart for products. I am dividing our market share by the total market. There are some types of products in the market that we do not sell, or do not sell any of them in some months, so the chart will leave their values out. I want those values to display as 0% instead of not being there. How could I do this?

[bramkn · Accepted solution]

use an If statement to check if it is null and then show 0% when true and normal value for false.