Essbase @MINSRANGE

Returns the minimum value of mbrName across XrangeList, with options to skip missing or zero
values.

Syntax

@MINSRANGE (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, mbrName [,XrangeList])
Parameter Description
SKIPNONE Includes in the operation all specified cells regardless of their content
SKIPMISSING Ignores all #MISSING values
SKIPZERO Ignores all 0 values
SKIPBOTH Ignores all 0 and #MISSING values
mbrName Any valid single member name or member combination, or a function that
returns a single member or member combination
XrangeList Optional. A valid member name, a comma-delimited list of member names,
cross dimension members, or a member set function or range function (including
@XRANGE) that returns a list of members from the same dimension. If XrangeList is not specified, Essbase uses
the level 0 members from the dimension tagged as time.

Notes

  • @MINSRANGE enables skipping of #MISSING and 0
    values, in contrast with the @MINRANGE function,
    which always includes these values in the calculation.
  • @MINSRANGE (SKIPNONE, mbrName, rangeList)
    is equivalent to @MINRANGE (mbrName, rangeList).
  • #MISSING values are considered to be less than
    positive data values and more than negative data values. If the data being
    calculated includes only positive and #MISSING values, @MINSRANGE
    returns #MISSING.
  • For all members, @MINSRANGE returns the value calculated for
    the specified member and range list.

Example

For both examples, assume a database similar to Sample Basic. The Measures
dimension includes two members: COGS (cost of goods sold) and OtherInc_Exp
(miscellaneous income and expenses). The data can include 0 and #MISSING values.
For both members of the Measures dimension, the result is the same–the minimum
value for the OtherInc_Exp member across the specified range.

Example 1

Qtr1_Min = @MINSRANGE(SKIPBOTH, OtherInc_Exp, Jan:Mar);

This example ignores the 0 value for Mar and produces the following
results:

                   Jan       Feb       Mar  Qtr1_Min
              ========  ========  ========  ========
COGS          #MISSING      1500      2300       350
OtherInc_Exp       500       350         0       350

Example 2

Qtr1_Min = @MINS(SKIPNONE, OtherInc_Exp, Jan:Mar);

This example does not ignore the 0 value in the calculation. This example
produces the following results:

                   Jan       Feb       Mar  Qtr1_Min
              ========  ========  ========  ========
COGS          #MISSING      1500      2300         0
OtherInc_Exp       500       350         0         0

See Also

  • @MINS
  • @MINRANGE
  • @MAXSRANGE