NotIn

Description

NotIn returns true when a value is not included in a specified list or set.

Syntax

NotIn(value, option1[, option2...])

Parameters

Parameter	Required	Type	Description
value	Yes	Field or expression	Value to check.
option	Yes	Constant or expression	Disallowed value.

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

NotIn(Region, "East", "West")

The expression returns the calculated result according to the current query context.