03-10-2022 11:12 AM - last edited on 05-24-2023 12:30 PM by JackLacava
Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks
03-10-2022 12:42 PM
Try this..should work
NumberFormat = [#,##0.00; #,##0.00 ;"-"]
03-10-2022 12:53 PM
This is exactly what I was looking for. Thanks!
03-10-2022 12:48 PM - edited 03-10-2022 12:52 PM
Thanks for asking the question. I learned something new as well.
This should work --
If (CellAmount = 0.00) Then
NumberFormat = "-"
Would appreciate a Kudo.
Cheers,
Mustafa
03-10-2022 03:49 PM
Make sure you consider the ExcelNumberFormat, ReportNoDataNumberFormat, and ReportNumericBindingFormat. A simple solution is to create some literal value parameters to use as formatting on the Cell Format Formatting within your cube views. Here's a sample of our standard number formatting for non percentage values.