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 color in SLA % is wrong.

How to solve it?

 

 

Need Help

3 Replies

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi,

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

  • 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!
     
     
  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    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