@NEXTS

Returns the nth cell value in the sequence rangeList from the mbrName. Provides the option to skip #MISSING, zero, or both #MISSING and zero values. Works within a designated range and retains all other members identical to the current member.

Syntax

@NEXTS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH mbrName[,n,rangeList])
ParameterDescription

SKIPNONE

Includes all cells specified in the rangeList operation, regardless of their content.

SKIPMISSING

Ignores all #MISSING values in the rangeList operation.

SKIPZERO

Ignores all 0 in the rangeList operation.

SKIPBOTH

Ignores all #MISSING and 0 values in the rangeList operation.

mbrName

Any valid single member name or member combination, or a function that returns a single member or member combination.

n

Optional signed integer. Using a negative value for n has the same effect as using the matching positive value in @PRIORS. If you do not specify n, then a default value of 1 is assumed, which returns the next prior member from the lowest level of the dimension set as Time in the database outline.

rangeList

Optional. A valid member, 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 set as Time.

Example

In this example, Next Cash for each month is derived by taking the Cash value for the following month and ignoring both #MISSING and zero values. Because n is not specified, the default is 1, which provides the next member in the range. Also, because rangeList is not specified, the level 0 members from the dimension set as Time are used (Jan,Feb,Mar, ...).

"Next Cash" = @NEXTS(SKIPBOTH, Cash);

The following report illustrates the above example:

             Jan     Feb    Mar    Apr    May    Jun
             ===     ===    ===    ===    ===    === 
Cash         1100    #MI    1000   1300     0    1400 
Next Cash    1000    1000   1300   1400   1400    #MI

See Also

  • @NEXT