Essbase @MIN

Returns the minimum value among the results of the expressions in expList.


@MIN (expList)
Parameter Description
expList Comma-delimited list of members, variable names, functions, and numeric
expressions, all of which return numeric values.


Depending on the values in the list, @MIN may return a zero(0) or #MISSING value.
For full control over skipping or inclusion of zero(0) and #MISSING values,
it is recommended to use the @MINS function
instead of the @MIN function.


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

See Also

  • @MINS
  • @MAX