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 18-6 List of Range Functions
Function | Calculation |
---|---|
The average value of a member across a range of members |
|
A range of members that is based on the relative position of the member combination Essbase is currently calculating |
|
The maximum value of a member across a range of members |
|
The maximum value of a member across a range of members, with the ability to skip zero and #MISSING values |
|
The next or nth member in a range of members, retaining all other members identical to the current member across multiple dimensions |
|
The minimum value of a member across a range of members |
|
The minimum value of a member across a range of members, with the ability to skip zero and #MISSING values |
|
The next or nth member in a range of members |
|
The next or nth member in a range of members, with the option to skip #MISSING, zero, or both values |
|
The previous or nth previous member in a range of members |
|
The previous or nth previous member in a range of members, with the option to skip #MISSING, zero, or both values |
|
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 |
The summation of values of all specified members across a range of members |