Forum Discussion
Conditional Formatting Rules not Correct, Wrong Results
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!!
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.
7 Replies
- Syk
Resident Rockstar
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
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
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.