DE.FIRST

Returns the first element in a specified dimension.

Syntax

DE.FIRST(Database alias,Dimension)

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 at the order of the elements as they are presented by the Dimension Browser.

If a non-existent dimension is entered, the function returns a #Value error.

This function is most commonly used with DE.NEXT.