How to exclude values in a Text calculated field that is used as a filter list/drop down
I have a filter list that lists user names. It is from a single column from my data source. I am trying to remove blanks and the value "N/A" from that list.
I see the CASE statement can be used, but not sure how to use to exclude values from this list.
Would it be something like:
CASE WHEN myField IN ("","N/A")THEN "" END
Can you use TRIM to trim all blanks from the CASE statement?