How to show Zero (instead of empty) in No Data cell
Originally posted by Hubert Gao
Hello,
In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell?
Thank you!
Forum Discussion
You can create a UD8 Member with a dynamic calc and select this member in CV´s POV.
If api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 &":U8#None").CellStatus.IsNoData Then
Return api.Data.CreateDataCellObject(0.0, False, False)
Else
Return api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 & ":U8#None").CellAmount
End If
But drill down will not work anymore.
Forgot this before
Dim Entity As String = api.Pov.Entity.Name
Dim Parent As String = api.Pov.Parent.Name
Dim Cons As String = api.Pov.Cons.Name
Dim Scenario As String = api.Pov.Scenario.Name
Dim Time As String = api.Pov.Time.Name
Dim View As String = api.Pov.View.Name
Dim Account As String = api.Pov.Account.Name
Dim Flow As String = api.Pov.Flow.Name
Dim Origin As String = api.Pov.Origin.Name
Dim IC As String = api.Pov.IC.Name
Dim U1 As String = api.Pov.UD1.Name
Dim U2 As String = api.Pov.UD2.Name
Dim U3 As String = api.Pov.UD3.Name
Dim U4 As String = api.Pov.UD4.Name
Dim U5 As String = api.Pov.UD5.Name
Dim U6 As String = api.Pov.UD6.Name
Dim U7 As String = api.Pov.UD7.Name
If api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 &":U8#None").CellStatus.IsNoData Then
Return api.Data.CreateDataCellObject(0.0, False, False)
Else
Return api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 & ":U8#None").CellAmount
End If