09-06-2022 01:47 PM - last edited on 05-24-2023 12:22 PM by JackLacava
I am trying to change the zeroes in my report to become '-'.
Can I accomplish the above with an If Statement?
09-06-2022 10:21 PM
Have you tried adding something like this in the Cell Format under Number Format? 0;-0;"-"? If you have a Custom Number Format, it follows the same formatting as Excel. Excel Custom Number Format offers 4 arguments. Argument 1 is for the Display of Positive Numbers, Argument 2 is for the Display of Negative Numbers, Argument 3 is for the Number Zero Format, and Argument 4 is for Text. There are plenty of links on this subject online.
Hope this helps
09-07-2022 11:20 AM
How would I transform my zeroes into dashes in OS though?
09-07-2022 11:36 AM
Add here in your Cube View and see what happens
09-07-2022 11:43 AM
The text is not available under the drop-down menu so the zeroes are now blanks instead of dashes.
09-07-2022 03:30 PM
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
09-07-2022 03:42 PM
Ok, for the Cell Format am I entering that information in Row or Column? Or below in the screenshot?