Is there anything else that these AGENCY_IDs have in common that would easily distinguish them from the others?
No, nothing else.
I was just wondering if there is a syntax that would work such as:
If [AGENCY_ID] = ('07508546', '07591640', '17209883', '39557711', etc) then 'OTA' ELSE [CHANNEL] END
(Obviously, I already tried that format, and it didn't work.)
1 of 1 people found this helpful
The formula could be written like the following:
If [AGENCY_ID] = '07508546' or [AGENCY_ID] = '07591640' or [AGENCY_ID] = '07560685' or.. etc then 'OTA' else [CHANNEL] end