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.
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?
Resident RockstarThe "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?
- 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
- Syk
Quick example: