3 Replies Latest reply: Aug 29, 2017 4:35 AM by Kyle Smith RSS

    Formatting 0 as - (a single dash)

    Kyle Smith

      Hi All,

       

      Hopefully this is easy, but I would like to format 0's in my pivot table as '-', so that they match with the null value fields. In Excel you could do it with a formula like this: #,##0;-#,##0;-

      Capture.PNG

      Thanks,

      Kyle