Not In

Returns TRUE if a given value is not in the specified list of values.

Syntax

Arg1 not in Arg2

Where:

Arg2 must be a list with one or more elements. Arg1 must be of the same data type as the elements in Arg2. Arg1 and Arg2 can be of any data type that MicroStrategy supports.

Example

Year not in (2002, 2003)

Returns TRUE if year is 2000, 2001, and so on.