Wrong conditional formatting color

[pang22]

Dears,

I set the below SLA% with below rules and colors and applied.

When I applied to "value and totals", the unit change to "number" but not "percent" and cannot edit.

And the color in SLA % is wrong.

How to solve it?

[_AAndrade]

Hi @pang22,

Did it solve your problem?
Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out

[Uzi2019]

Hi @pang22 

Sometimes the condition formatting does not give you correct color based on your condition. It is recommended that you create measure for color code.
create color measure and appy on font color 

color = if([CPC]<=85,"Red",IF(AND([CPC]>85,[CPC]<=95),"Yellow","Green"))

select field formatting and select your color measure from there.

I hope this resolved your issues!

[_AAndrade]

Hi,

Try to put all your conditions as number and adjust the number, for example:
>= 0.85 number and <=0.95