Conditional Formatting Rules not Correct, Wrong Results

[Anonymous]

Conditional Formatting Rules not behaving correctly. Rules are posted below with the results seen in the other picture. I've tried the swapping over to decimals trick and from percentages to numbers but this has not worked either. 

Each of the bands I'm trying to achieve can be seen in the conditional formatting page, but only red is showing up 

PS I know about having two rules that include = 0, whenever I swap the red to be just > 0 it swapes it back when I click off of it. 

Any help greatly appreciated, Thank you!!

[Anonymous]

69.23% which is well within the rules range. Strange result. 

[Syk]

You're only getting red because you don't have any values > 22 so all of them fall into the red bucket except for the 0s 

[Anonymous]

I thought that this should be calculating whether it is equal to that percentage of the value in the previous column. So if the total is 9 and the approved is 9 then 100% which is green. If the total is 6 and the approved is 5 then 84% which is red.

Is it not based off the row values?

If that's not how it works then I'm going to have to create a column that does this calculation and then base the conditional formatting off of that?

[Syk · Accepted solution]

The "What field should we base this on?" will mean that it ONLY looks at that value. If you want an approval % that's approved/total then you just need to create a measure to do that and select it as the field to base the conditional formatting on.

[Syk]

Quick example:

[Anonymous]

Ahh okay, Thank you.  I've done that now and it's worked for the most part. I think the documentation on conditional formatting needs to be clearer. 

Would you happen to know why I've got one result that isn't working? 

[Syk]

While troubleshooting, add the Approval % to see what it's evaluating to in the table. Should let you know why that value is off