IN (Report Builder 1.0)
Determines whether an item is a member of a set.
Syntax
IN(item, set)
item |
Indicates the item to be tested for to determine if it is included in a set. |
set |
Specifies the values within which to determine if the item is a member. |
Remarks
All values in the set must be literal values.
A set must contain at least one value.
All values within the set must have the same type.
Boolean values are not allowed in a set.
Sets containing literal EntityKey values are not displayed and cannot be entered.
Example
Formula |
Result |
|---|---|
IN(State Province, {"California", "Oregon", "Washington", "Alaska"}) |
All values listed in the State Province field are compared to the formula filter condition. All State Province records that match the set (California, Oregon, Washington, or Alaska) are displayed in the report. |