Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Number Formatting: Zeros not to be visible

Please introduce a format so that zeros can either not be displayed at all or they can be displayed as a dash. An accounting style format would work. It gets tedious to rely on if statements to return blanks, conditional formatting, or filters. Thanks.
Status: Needs Votes
Comments
GGotla
New Member
Yes, the ability to set 0 to a "-" would be extremely useful, especially when calculating variances for multiple lines, without using the Format function which can affect Totals.
fbcideas_migusr
New Member
Status changed to: Needs Votes