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

You have the data and can test different values.  From observing it 17.95% (or 0.1795)  will fall in the 0 to 0.9 range therefore green.

There's no provision for -ve numbers from what I can see so it'll either do nothing or assign it to the last case.  Why don't you add a case for -ve numbers?