
Contributor II
2017-08-24
09:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Formatting 0 as - (a single dash)
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
- Tags:
- value format
1,462 Views
1 Solution
Accepted Solutions

MVP
2017-08-24
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1,380 Views
3 Replies

MVP
2017-08-24
11:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be do like this
If(Expression = 0, Null(), Expression)
1,381 Views

Anonymous
Not applicable
2017-08-24
11:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe use an If:
If ( YourExpression = 0 , null() , YourExpression )
Then it actually will be Null().

Contributor II
2017-08-29
04:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
