Range Functions

Table 52 lists range functions, which allow you to execute a function for a range of members:

Table 52. List of Range Functions

Function

Calculation

@AVGRANGE

The average value of a member across a range of members

@CURRMBRRANGE

A range of members that is based on the relative position of the member combination Essbase is currently calculating

@MAXRANGE

The maximum value of a member across a range of members

@MAXSRANGE

The maximum value of a member across a range of members, with the ability to skip zero and #MISSING values

@MDSHIFT

The next or nth member in a range of members, retaining all other members identical to the current member across multiple dimensions

@MINRANGE

The minimum value of a member across a range of members

@MINSRANGE

The minimum value of a member across a range of members, with the ability to skip zero and #MISSING values

@NEXT

The next or nth member in a range of members

@NEXT

The next or nth member in a range of members, with the option to skip #MISSING, zero, or both values

@PRIOR

The previous or nth previous member in a range of members

@PRIORS

The previous or nth previous member in a range of members, with the option to skip #MISSING, zero, or both values

@SHIFT

In some cases, @SHIFTPLUS or @SHIFTMINUS

The next or nth member in a range of members, retaining all other members identical to the current member and in the specified dimension

@SUMRANGE

The summation of values of all specified members across a range of members