Formatting 0 as - (a single dash)

[kyle_smith_eni]

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;-

Thanks,

Kyle

[sunny_talwar · Accepted solution]

May be do like this

If(Expression = 0, Null(), Expression)

[Anonymous]

Maybe use an If:

If ( YourExpression = 0 , null() , YourExpression )

Then it actually will be Null().

[kyle_smith_eni]

Thanks Sunny, that worked perfectly!

It would be great if there were additional formatting options so that 0 could be formatted separately, as in Excel.