Skip to main content
S
SaBrien
May 3, 2024
Solved

Cube View NoData Formatting in Excel

  • May 3, 2024
  • 2 replies
  • 1 view

Is there a way to format 'NoData' cells so that when the report exports to excel it shows a dash or 0, instead of the cell being blank?

Best answer by tuhler

Hi,

I was able to accomplish this using UD8 dynamic calc. By setting up a dynamic calc to return a 0 if IsNoData is TRUE. Then you can use the Excel formatting as Krishna mentioned.

Dim cellCheck As DataCell = api.Data.GetDataCell("UD8#None")

If cellCheck.CellStatus.IsNoData() Then
      Return 0
Else
     Return api.Data.GetDataCell("UD8#None").CellAmount
End If

Thank you,

Thomas Uhler

2 replies

K
Krishna
May 3, 2024

SaBrien  - Try this setting in the CV Cell Format in Excelformat  ExcelNumberFormat = [#,###,0;(#,###,0);-]

 


Krishna_0-1714751039587.png

 

S
SaBrienAuthor
May 3, 2024

We've tried many variations using the excel number format but none seem to work. Any cell that has 'NoData' will be blank and we were wanting them to show zeros.

T
tuhlerAnswer
May 3, 2024

Hi,

I was able to accomplish this using UD8 dynamic calc. By setting up a dynamic calc to return a 0 if IsNoData is TRUE. Then you can use the Excel formatting as Krishna mentioned.

Dim cellCheck As DataCell = api.Data.GetDataCell("UD8#None")

If cellCheck.CellStatus.IsNoData() Then
      Return 0
Else
     Return api.Data.GetDataCell("UD8#None").CellAmount
End If

Thank you,

Thomas Uhler

Terms & ConditionsAccessibility statement