ELISCOMP
ELISCOMP determines whether element1 is a child of element2 in the specified dimension. The function returns TRUE if element1 is a child of element2, otherwise the function returns FALSE.
This worksheet function is valid in worksheets only.
Syntax
ELISCOMP(dimension, element1, element2)
Argument |
Description |
---|---|
dimension |
A valid dimension name. |
element1 |
The name of an element within the dimension. This argument can also be the name of an alias for a dimension element. |
element2 |
The name of an element within the dimension. This argument can also be the name of an alias for a dimension element. |
Example
ELISCOMP("Region","Germany","Central Europe")
In the dimension Region, the element Central Europe is a consolidation of two elements, Germany and France. The example returns TRUE.
Note that this function returns TRUE only for immediate children. In the above example, Germany is a child of Central Europe. Further, Central Europe is a child of Europe. However, because the function returns TRUE only for immediate children, the following example returns False:
ELISCOMP("Region","Germany","Europe")