How to show percentOfTotal as hyphen when the sum of the field is 0

Question & Answer
, ,
1

Hi,

I have a requirement to show sales values as 0 for product type, when no data present for the selected filters. The Analysis also has a percentage of total field to be shown. When the sales values for all the product types are 0, the percentage comes as blank. Which may make sense since the denominator becomes 0.

in such scenarios, Is there a way to show the value as Hyphen instead of blank?

I tried Format > More Formatting Options > Null Values > Show custom
and added Hyphen there.

It did not work, I think because the values here are not null but 0.

Any help appreciated.

Thank you.

2

Hmm it looks like I can only do it with rows/ columns and not the values.

I will mark this as a feature request as I think it will need to be added as a feature.

3