Forum Discussion
Conditional Formatting Rules not Correct, Wrong Results
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.
Resident RockstarYou'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.
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?