The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Variance Explanation Cube View
Hello,
Is there a way to format a cube view column for variance explanation to be a certain color/have text in the cell based on the variance column? The attached/below is what we want it to look ...
How are you populating the Variance Explanation in your screenshot above? You'll likely need a Dynamic Calc for that which will read the amount and then return a string of text to one of our Annotation View members. You won't be able to use a Dynamic Calc for the formatting portion. You'll have to use a BRString which is entered to the cell formatting property of the column.
EricOsmanski I don't have a dynamic calc to populate the "Commentary Required". I was hoping to have the same dynamic calc populate both the "Commentary Required" and the background color. Is there a way to update the string you provided to be based on cell amount? Thank you!
EricOsmanskiOneStream Employee
How are you populating the Variance Explanation in your screenshot above? You'll likely need a Dynamic Calc for that which will read the amount and then return a string of text to one of our Annotation View members. You won't be able to use a Dynamic Calc for the formatting portion. You'll have to use a BRString which is entered to the cell formatting property of the column.