@MINS

The @MINS calculation function for Essbase returns the minimum value from results of expressions in a member list, with options to ignore empty values.

This function returns the minimum value across the results of the expressions in expList, with options to skip missing or zero values (in contrast with @MIN, which cannot ignore empty values).

Syntax

@MINS (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)

Parameters

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

This function enables skipping of #MISSING and 0 values, in contrast with @MIN, which always includes empty 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