Forum Discussion

blaj's avatar
blaj
Icon for Helper I rankHelper I
2 years ago

How do you color code a calculation group using field value?

If you have a calculation group in a matrix that calculates % change for over 20 selected measures, how do you color code % change based on field value without getting a numeric/date error?   Any w...
General Comment
Need Help
Tips and Tricks
ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

Hi blaj , give this a try, and if you encounter any issues, let me know.

Create a Color Coding Measure

 

ColorCode = 
SWITCH(
    TRUE(),
    [% Change] > 0.1, "Green",
    [% Change] < -0.1, "Red",
    "Black"
)

 

 

Modify the Calculation Group Item

 

FORMAT(
    [% Change],
    SWITCH(
        TRUE(),
        [% Change] > 0.1, "<span style='color:green'>" & FORMAT([% Change], "0.00%") & "</span>",
        [% Change] < -0.1, "<span style='color:red'>" & FORMAT([% Change], "0.00%") & "</span>",
        "<span style='color:black'>" & FORMAT([% Change], "0.00%") & "</span>"
    )
)

 

 

Did I answer your question?  If so, please mark my post as the solution!✔️
Your Kudos are much appreciated!  Proud to be a Responsive Resident!