Forum Discussion

YanSavinsky's avatar
YanSavinsky
New Contributor III
4 years ago
Solved

Conditional Formatting in CubeView in the "annotation" or other "Text" cell

I would like to apply conditional formatting to a Cube View column that contains "Annotation", "Variance Explanation" or other textual data. I have tried  IsNoData and "CellAmount" conditions, but ...
Cube View
  • LeeB's avatar
    LeeB
    3 years ago

    If you set the UD8 to Return a 1 if an explanation or 0 if not required.

    Then set up a Delimited List Parameter where 1, 0 are the values and your Explain / Not Required text strings are the Display items.

    Then set your CV column up to use this Combo Box as follows, note Modify Data = False means the cell will not allow drop down.

     

    The cell value in the Cube View will display as Explain / Not Required but the cell amount will actually be 1 / 0 allowing you to perform conditional formatting.

     

     

SandeepSingh's avatar
SandeepSingh
New Contributor
3 years ago

 

Hi Nicole/Lee and All,

Need some help here pls. In cube view i needs to populate NM where there is "NODATA", i did played around with cellformat formula (see screenshot) still no success. Please help.

 

Thanks..Sandeep S

NicoleBruno's avatar
NicoleBruno
Valued Contributor
3 years ago

Also - I think the syntax is Contains instead of Contain