Colour Conditioning for perecntages for in chart text

[aaronnayan]

Hi Guys

I have an expression

I am trying to color code the text

My value is a percentage

Below keeps the value to green

And it does not change

This is not working:

=IF(vUT%>=0.0 and vUT% <= 0.5, RED(),

IF(vUT%>=0.51 and vUT% <= 0.7, YELLOW(),

Green()))

[ankur_abhishek]

Hi Aaron,

Could please provide the sample value of vUT% field so that i can provide you the solution

Thanks

Ankur 

[prat1507]

Hi

Can you plz share a sample app?

Regards

Pratyush

[Anil_Babu_Samineni]

Can you use Square Brackets ([]) around your expression. What does the expression for vUT% and how values are looks like?

=IF([vUT%] >= 0.0 and [vUT%] <= 0.5, RED(),

IF([vUT%]>=0.51 and [vUT%] <= 0.7, YELLOW(),

Green()))

[aaronnayan]

Im sorry pratyush i cannot,

the value stays green and does not change to red or yellow depending on what it is

i.e: If the percentage is lower than 50% it should be red

higher than 70% it should be green

[prat1507]

Hi

Can you just give me an idea as to how you've declared the variable?

Regards

Pratyush

[aaronnayan]

vUT%= (avg(Aggr(sum(JO_)/(TGT),_Vehicle)))

HTH

[prat1507]

It is giving green coz it is not satisfying any of the conditions above, try to use the variable in text. Capture its value and then try to check that in your condition.

Regards
Pratyush

[devarasu07 · Accepted solution]

=IF((sum(Sales)/sum(Total Sales))>=0.0 and (sum(Sales)/sum(Total Sales)) <= 0.5, RED(),

IF((sum(Sales)/sum(Total Sales))>=0.51 and (sum(Sales)/sum(Total Sales)) <= 0.7, YELLOW(),

Green()))

[aaronnayan]

Sorry could you explain more?