Reputation: 671
Two questions: 1. I have a report that I need to change the font color if the threshold value is not met. If CompositeV < .90 the font color should be RED else BLACK.
I have the color coded indicator, but I need to change the font color if it is less than .90 to red.
Upvotes: 0
Views: 20053
Reputation: 580
I would create a calculated field:
If CompositeV < .90
THEN "RED"
ELSE "BLACK"
END
And then add that field to the color shelf. I think I'd need more information about what type of indicator you're looking for? You could use that calculated field to further indicate which values met your condition.
Upvotes: 4