@MIN

The @MIN calculation function for Essbase returns the minimum from a list of numeric values.

Syntax

This function returns the minimum value among the results of the expressions in expList.

@MIN (expList)

Parameters

expList: Comma-delimited list of members, variable names, functions, and numeric expressions, all of which return numeric values.

Notes

Depending on the values in the list, @MIN may return a zero(0) or #MISSING value. For full control over skipping or inclusion of empty values, use @MINS.

Example

In the Sample Basic database:

Qtr1 = @MIN(Jan:Mar);

produces the following report:

            Colas   New York   Actual                      
          Jan     Feb     Mar     Qtr1
          ===     ===     ===     ====
Sales     678     645     675     645