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

XtensibilityGuy
New Contributor

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

4 REPLIES 4

Sai_Maganti
Contributor II

Try this..should work

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

This is exactly what I was looking for. Thanks!

Mustafa_A
Contributor II

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
Contributor III

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