Forum Discussion

Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Conditional formatting of measures

Hi,   I have multiple measures in my report and I want to make the font color change based on the value of the measure.    Let's say i have two measure; measure A and measure B, which are both pe...
Need Help
Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Hi alish_b ,

 

Sales Color = GetColor([Sales])
Profit Color = GetColor([Profit])

Would i have to make a coloring measure for all measures that follow this formatting? Or can I reference it in the coloring value function?

Trescher's avatar
Trescher
Frequent Visitor
8 months ago

Btw i get the following error, some syntax related issue.

 

 

  • alish_b's avatar
    alish_b
    Icon for Super User rankSuper User
    8 months ago

    Oh my bad! Used a reserved word in there. Try this:

    DEFINE FUNCTION GetColor = ( measurevalue: NUMERIC ) => IF(measurevalue > 0, "#00B050", "#FF0000")
    EVALUATE { GetColor(100) }