Zeroes into -
I am trying to change the zeroes in my report to become '-'.
Can I accomplish the above with an If Statement?
Forum Discussion
I tested with a Cube View with derived 0's
Used [#,###,0;(#,###,0);"-"] in Number Format for Cell Format
Zeros turned in dashes
Also worked in a If Statement
If (CellAmount = 0.00) Then
NumberFormat = [#,###,0;(#,###,0);"-"]
Else
NumberFormat = [#,###,0;(#,###,0);0]
End If
Ok, for the Cell Format am I entering that information in Row or Column? Or below in the screenshot?