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.

For example:

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

--> Community Manager update [Ciara Brennan]

Marked as Planned

cc'ing Thomas Nhan