Returns the nth cell value in the sequence rangeList from mbrName, retaining all other members identical to the current member. @NEXT cannot operate outside the given range.
Syntax
@NEXT (mbrName [, n, rangeList])
| Parameter | Description |
|---|---|
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
n | Optional signed integer. If you do not specify n, then the default is set to 1, which provides the next member in the range. Using a negative value for n has the same effect as using the matching positive value in the @PRIOR function. |
rangeList | Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions. If rangeList is not specified, Essbase uses the level 0 members from the dimension tagged as Time. |
Example
In this example, Next Cash for each month is derived by taking the Cash value for the following month. Since n is not specified, the default is 1, which provides the next member in the range. Since rangeList is not specified, the level 0 members from the dimension tagged as Time are used (Jan,Feb,Mar, ...).
"Next Cash" = @NEXT(Cash);
This example produces the following report:
Jan Feb Mar Apr May Jun
=== === === === === ===
Cash 100 90 120 110 150 100
Next Cash 90 120 110 150 100 #MISee Also