IsInList

Returns True if the member is found in the specified list.

Syntax

IsInList(List,Member,WhereFrom)
ParameterDescription
ListAn array of members
MemberMember for which to search in the specified list
WhereFromMethod name from which IsInList is invoked

Return Value

Returns an array of Period members based on the specified Scenario member default frequency.

Example

IsInList(SalesList, “East”, “Sub calculate”)