1 of 1 people found this helpful
By its nature CASE compares values one at a time, but you can use OR with IF, like:
IF [Market] = 'East' OR [Market] = 'West' THEN 'blah'
Is the attached what you are looking for?
I use a field as follows:
CASE [Region]='East' OR [Region]='West'
WHEN TRUE Then "East or West"
WHEN FALSE then "Not east or west"
or in a case statement.twbx.zip 30.6 KB