I would like an equivalent to the SQL 'IN' operator. Currently the only way to compare a list of values is by using an OR operator. This is very cumbersome when comparing a large list of values.
IF [Country]='HONDURAS' OR [Country]='MEXICO' OR [Country]='PERU' OR [Country]='COLUMBIA' OR [Country]='ARGENTINA' THEN 'AMERICAS' ELSE 'OTHER' END
What I am used to doing in SQL is this:
IF [Country] IN ('HONDURAS','MEXICO','PERU','COLUMBIA','ARGENTINA') THEN 'AMERICAS' ELSE 'OTHER' END