Forum Discussion

BrianMillerDL's avatar
BrianMillerDL
New Contributor
2 years ago

CubeView not displaying literal value

I have a cube view that displays values that are entered monthly. For the months that haven't had any data entered yet, it automatically fills in a 0 in a greyed-out format. Similarly, if I display this same row in a YTD view, it shows the YTD value in the months that have not been entered in yet. My customer would prefer these cells display no value. I cannot find any setting or formatting that will display it that way.

I've tried changing the number format to empty string ("") based on IsNoData or IsDerived but that has not yielded the desired result.

 

 

  • Hweeli's avatar
    Hweeli
    New Contributor III

    Hi BrianMillerDL,

    Try Condition formatting:

    If (IsDerivedData = True) Then
    TextColor = Transparent
    End If

    Hwee Li