Inconsistent Text Display (Formula driven)
I am seeing inconsistent display of text color based on a field text selection in any report I use the fields in. For example: Budget Status field (text-mult choice) is "At Risk". A separate field Bud...
Forum Discussion
.. or if you suspect data is contaminated or inconsistent, you can also use
IF(Trim([My field]) = "At Risk", "yellow")
The Trim will trim away and leading or training invisible characters like spaces.
IF(Trim([My field]) = "At Risk", "yellow")
The Trim will trim away and leading or training invisible characters like spaces.