No Data Formatting

[MorganBiscoe]

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?

[Ashok]

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

[Henning]

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.

https://community.onestreamsoftware.com/t5/Office-Hours/Can-Cube-Views-display-accounting-format-for... 

[MorganBiscoe]

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