The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

SaBrien's avatar
SaBrien
New Contributor III
2 years ago
Solved

Cube View NoData Formatting in Excel

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?
Cube View
  • tuhler's avatar
    tuhler
    2 years ago

    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

tuhler's avatar
tuhler
New Contributor III
2 years ago

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