Forum Discussion

JordanJackson's avatar
JordanJackson
Advocate II
3 years ago

Conditional Formatting not working as intended

Hi,    I've out in place rules for the conditional formatting of this card (seen in the attached screenshot) and the formatting does not work how the rules state it should.    This same thing...
Need Help
HotChilli's avatar
HotChilli
Community Champion
3 years ago

Try putting the numbers in decimal where 0 = 0 and 1 = 100 in that screen.  So 0.9 instead of 90 for example.

  • JordanJackson's avatar
    JordanJackson
    Advocate II
    3 years ago

    Doing this has fixed some results, but not all. 

     

    I have a result with 17.95% and another with -41.03 that both present as green. According to the rules the 17.95 should appear as red.

     

    I'm stumpped as to what the cause is.

    • v-yinliw-msft's avatar
      v-yinliw-msft
      Community Support
      3 years ago

      Hi JordanJackson ,

       

      Could you please change the type number to type percent?

      Because you have the percentage and the decimal number.

       

      Hope these help you.

       

      Best Regards,

      Community Support Team _Yinliw

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.