Forum Discussion

jpowers's avatar
jpowers
New Member
9 years ago

Zero Value Formatting

How do I get zeros to show as dashes like accounting formatting in excel?
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
9 years ago

jpowers,

 

You could add a calculated column.

Column =
IF ( Table1[Column1] = 0, "-", Table1[Column1] & "" )
jpowers's avatar
jpowers
New Member
8 years ago

This converts the numbers to text and then I am unable to sum.