Forum Discussion

JordanJackson's avatar
JordanJackson
Icon for Advocate II rankAdvocate 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
Icon for Community Champion rankCommunity 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
Icon for Advocate II rankAdvocate 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
    Icon for Community Support rankCommunity 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.