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


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.


  • @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.


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

                   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