Returns the minimum value across the results of the expressions in expList, with options to skip missing or zero values.
@MINS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)
| SKIPNONE | Includes in the operation all cells specified in expList regardless of their content |
| SKIPMISSING | Ignores all #MISSING values |
| SKIPZERO | Ignores all 0 values |
| SKIPBOTH | Ignores all 0 and #MISSING values |
| expList | Comma-delimited list of member names, variable names, functions, or numeric expressions. expList provides a list of numeric values for which Analytic Services determines the minimum value. |
#MISSING and
0 values, in contrast with @MIN, which
always includes these values.#MISSING values are less than positive data values
and more than negative data values, if the data being calculated includes
only positive and #MISSING values, @MINS returns #MISSING.#MISSING
values,@MINS may return either #MISSING or 0 values
in an unpredictable manner.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.
Qtr1_Min = @MINS(SKIPBOTH, Jan:Mar);
This example ignores #MISSING and 0 values for all members
of the Measures dimension. This example produces the following results:
Jan Feb Mar Qtr1_Min
======== ======== ======== ========
COGS #MISSING 1500 2300 1500
OtherInc_Exp -500 -350 0 -500
Qtr1_Min = @MINS(SKIPNONE, Jan:Mar);
For all members of the Measures dimension, this example includes #MISSING
and 0 values and produces the following results:
Jan Feb Mar Qtr1_Min
======== ======== ======== ========
COGS #MISSING 1500 2300 #MISSING
OtherInc_Exp -500 -350 0 -500
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |