DE.INDEX

Returns the index number for a specified element in a specified dimension. DE.INDEX is one-based and so returns 1 for the first element in the dimension. If an element is not found, the function returns 0.

Syntax

DE.INDEX(Database alias,Dimension,Element)

Dimension is the name of the dimension containing the element whose index number you want to determine and Element is the element.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.

Note: This function looks at the order of the elements within a dimension as they were defined when the dimension was created, not the order of the elements as they are presented by the Dimension Browser.

If the selected dimension or element does not exist, the function returns a #Value error.