Forum Discussion

YanSavinsky's avatar
YanSavinsky
New Contributor III
3 years ago

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 with no success.

 

I would appreciate any direction.

Thank you!

 

Yan Savinsky

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.

     

     

  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    Hi Yan, 
    This is what we're using for values, formatting the cell to be red when it's not zero: 

    We also use this to call out intercompany accounts on a different CV: 

    Maybe the issue is in the formatting of the conditional request? Hope the above are useful. 

     

    • YanSavinsky's avatar
      YanSavinsky
      New Contributor III
      3 years ago

      Thank you, Nicole!

      The row I am trying to apply conditional formatting to has View dimension set to V#Annotation so it has text in the cells instead of numbers. I tried the "CellAmount" condition and it does not work. I also tried "IsNoData" with no success. Basically I want to change the background of the cells with "Explain --->" text in them.

      If (CellAmount = "Explain --->") Then

      BackgroundColor = Yellow

      End If

      If (IsNoData <> True) Then

      BackgroundColor = Yellow

      End If

       

       

      • NicoleBruno's avatar
        NicoleBruno
        Valued Contributor
        3 years ago

        Hi, 

        How is the cell getting "Explain --->" in it to begin with? Is that text based on something that you could use for your conditional formatting (ie. Var % column >100)? 

  • ckattookaran's avatar
    ckattookaran
    VIP
    3 years ago

    If you use a cubeview extender rule, you might get some leverage (Not tested). However, I don't think the UI has anything related to TextValue.

  • 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

  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor
    3 years ago

    Hi Sandeep, 

    Should the portion inside the red box be "If (CellAmount..." instead of RowName?

    • SandeepSingh's avatar
      SandeepSingh
      New Contributor
      3 years ago

      Thanks.i will try that. In order to keep going developed the report in XFDOC. Its working fine in excel :).