Forum Discussion

pang22's avatar
pang22
Icon for Helper III rankHelper III
2 years ago

Wrong conditional formatting color

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 col...
Need Help
Uzi2019's avatar
Uzi2019
Icon for Community Champion rankCommunity Champion
2 years ago

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!