MEMBER
Use MEMBER when you need to know whether an object occurs within a series.
The MEMBER function searches a series, looking for a single specified object in the series. If any object in the series matches the specified object, MEMBER returns "true". If there is no match, MEMBER returns "false".
- Syntax:
- MEMBER (single-object-expression ,
series-object-expression)
MEMBER (single-object-expression , { literal, literal ... })
- Meaning:
- MEMBER (object_to_look_for , series_of_objects_to_look_at)
- Returns:
- "True" or "false"
MEMBER returns "true" if object_to_look_for matches one of the values in series_of_objects_to_look_at.
It returns "false" if object_to_look_for does not match at least one of the values in series_of_objects_to_look_at.
The two arguments, object_to_look_for and series_of_objects_to_look_at, must be objects of the same item interpretation or the same group type. For example, if object_to_look_for is a date/time item, series_of_objects_to_look_at must be a series of date/time items.
Examples
- MEMBER (EntityIDCode:Name, {"BT" , "ST"})
This example tests whether EntityIDCode has one of a particular set of literal values.
- MEMBER (Store# , EntityIDCode:Name)
This example tests whether Store# has the same value as any EntityIDCode:Name.
Related functions
- EXTRACT
- LOOKUP