How to show zero when null value

[gidon500]

hi huys

enclosed a document that show - when value is null

how can i make it show  0

as when we export to excel there is lot of work to do to replace  - to 0

thanks

gidon

[m_woolf · Accepted solution]

On the Chart Properties|Presentation tab, set the Missing Symbol to zero.

[vincent_ardiet]

Hi,

Try to put a zero in the "Missing Symbol" field in the Presentation Tab of your object.

Regards,

Vincent

[sunny_talwar]

See if this helps:

[rubenmarin1]

Hi gidon, PFA.

I unchecked the option to supress zeros. AS a result it shows all the PN# so I changed it to a calculated dimension to show only the values with quantity or $

[gidon500]

thanks you guys

you are all great

gidon