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 ...
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?
Syk
Resident Rockstar
Resident RockstarWhile troubleshooting, add the Approval % to see what it's evaluating to in the table. Should let you know why that value is off