Range Functions

Range functions allow you to execute an Essbase function for a range of members, based on their position, value, or other factors.

Table 17-6 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
@NEXTS	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