Returns TRUE if the current member is an ancestor of the specified member. This function excludes the specified member.
Syntax
@ISANCEST (mbrName)| Parameter | Description |
|---|---|
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
Example
In the Sample Basic database:
@ISANCEST(California)
Returns TRUE for Market, West
@ISANCEST(West)
Returns FALSE for California, West, East
See Also