Skip to main content
M
MorganBiscoe
Member
February 2, 2023

No Data Formatting

  • February 2, 2023
  • 3 replies
  • 0 views

Hello,

 

I'm trying to format No Data cells as dashes on some cube views. Currently, the number format for the cube view is as follows: [#,##0;(#,##0);-]. This is formats zeros as dashes, but not No Data cells. Is anyone aware of a special formatting to change No Data cells?

3 replies

A
Ashok
Contributor
February 2, 2023

I have also been looking for this issues but it is not possible as per my knowlegde. 

H
OneStream Employee
HenningOneStream Employee
OneStream Employee
February 3, 2023

Hi, not that I am aware of (at least not for Cube Views). If needed, you can set up a dynamic member in a UD for reporting with the following formula (in this example, the member is being set up in UD8):

 

'Return "0" for empty cells
If api.Data.GetDataCell("U8#None").CellStatus.IsNoData Then
Return api.Data.CreateDataCellObject(0.0, False, False)
Else
Return api.Data.GetDataCell("U8#None").CellAmount
End If
 
See also this post, there is an enhancement request as well mentioned.
    M
    MorganBiscoeAuthor
    Member
    February 3, 2023

    Oh thank you I think that'll work for what I need! Also good to know that is a enhancement coming in the future.

    Terms & ConditionsAccessibility statement