Forum Discussion

MorganBiscoe's avatar
MorganBiscoe
New Contributor II
2 years ago

No Data Formatting

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?

Reports
  • Henning's avatar
    Henning
    Valued Contributor II
    2 years ago

    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.
  • Ashok's avatar
    Ashok
    New Contributor III
    2 years ago

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

  • MorganBiscoe's avatar
    MorganBiscoe
    New Contributor II
    2 years ago

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