Forum Discussion
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 ...
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.
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.
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
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)?
I am using a UD8 member with the member formula. Formula checks that both amount and percent variances exceed specific thresholds and if they do, places "Explain --->" in the V#Annotation for that account.
I am thinking I will have to add similar checks in the CubeView Extender BR and apply formatting that way.
CubeExtender does it only for a report. I don't think it'll do that on "Data Explorer." Keep that in mind when you go ahead with it.
