ELPARN

ELPARN returns the number of parents of an element in a specified dimension.

This worksheet function is valid in worksheets only.

Syntax

ELPARN(dimension, element)

Argument	Description
dimension	A valid dimension name.
element	The name of an element within the dimension. This argument can also be the name of an alias for a dimension element.

Example

ELPARN("Model","Wagon 4WD")

In the Model dimension, the element Wagon 4WD is a child of both Total Wagons and Total 4WD. Therefore, both Total Wagons and Total 4WD are parents of Wagon 4WD. The function returns 2.