Forum Discussion

sp8's avatar
sp8
Icon for Helper II rankHelper II
6 years ago

Conditional Formatting by other measure column not formating correctly

I am using the conditional formatting by another field feature on the table and it's formatting things incorrectly. I have a table column that contains the targets/goals and a column that has the ac...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Please change the type Percent to Number, It will work.

sp8's avatar
sp8
Icon for Helper II rankHelper II
6 years ago

Anonymous 

When I change both to number,  everything is green.

 

I would expect that, because it's comparing it to a specific number, which all of them are lower than, right?

I changed the 99.9 to .999 (like it's a percentage) and I still get nonsense colors. It doesn't follow any logic.