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