Forum Discussion

jpowers's avatar
jpowers
New Member
8 years ago

Zero Value Formatting

How do I get zeros to show as dashes like accounting formatting in excel?

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    I am not aware of how kind of formatting, maybe using the FORMAT function?

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 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.