How to make it display red when -ve and Green when +ve ?

[paulyeo11]

Hi All

I want to make the text color display red when the value is -ve and green color when +ve.

I have place the below expression at condition color   :-

if($(vSalesVariance) >0 ,'#46C646','#d01919')

But the color does not change. Hope some one can advise me where i go wrong ?

Paul

[sunny_talwar]

Added = in front of your variable definition. See if it is working now

[paulyeo11]

Hi Sunny

I just check , both -ve and +ve it display Red color.

Paul

[sunny_talwar]

I am not sure what you button is doing. How did you get a positive value for the same expression?

[paulyeo11]

Hi Sunny

When SOURCE = TDSID , It will display +ve

When SOURCE = ADL , It will display -ve

Paul

[sunny_talwar · Accepted solution]

Check it out now

[paulyeo11]

Hi Sunny

Many thank , now all my KPI work fine.

Now the expression is more simplify. But need to adjust the color bar in order to make it. Also after paste the expression into the box , it turn to become number. Don't ready understand but it work.

Paul