Essbase @MINS

Returns the minimum value across the results of the expressions in expList, with options to skip missing or zero values.

Syntax

@MINS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)
Parameter Description
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 Essbase determines
the minimum value.

Notes

  • @MINS enables skipping of #MISSING and 0 values,
    in contrast with @MIN,
    which always includes these values.
  • @MINS (SKIPNONE, expList)
    is equivalent to @MIN (expList).
  • Because #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.
  • If the data being calculated includes only negative, 0, and #MISSING values,@MINS
    may return either #MISSING or 0 values in an unpredictable manner.

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.

Example 1

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

Example 2

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

See Also

  • @MINSRANGE
  • @MAXS
  • @MIN