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...
Forum Discussion
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
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.