Skip to main content
Newcomer
Mar 10, 2022 4:12 PM UTC

Format to show "-" when "0" within cubeviews

Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks

4 replies

Member
Mar 10, 2022 5:42 PM UTC

Try this..should work

 NumberFormat = [#,##0.00; #,##0.00 ;"-"]

Newcomer
Mar 10, 2022 5:53 PM UTC

This is exactly what I was looking for. Thanks!

Contributor
Mar 10, 2022 5:48 PM UTC

Hi XtensibilityGuy 

Thanks for asking the question. I learned something new as well.

This should work -- 

 

    If (CellAmount = 0.00) Then
        NumberFormat = "-"

 

Mustafa_A_1-1646934449482.png

 

Would appreciate a Kudo. 

Cheers,

Mustafa 

 

 

 

aricgresko
Veteran
Mar 10, 2022 8:49 PM UTC

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.

aricgresko_0-1646945295139.png