@MINRANGE

Function

The @MINRANGE() function returns the minimum value of mbrName across rangeList.

Syntax

@MINRANGE (mbrName [ ,rangeList])

mbrNameAny valid single member name or member combination, or a function that returns a single member or member combination.
rangeListOptional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.

Notes

Depending on the values in the list, @MINRANGE 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 @MINSRANGE function instead of the @MINRANGE function.

Example

In the Sample Basic database:

Qtr1 = @MINRANGE(Sales,Jan:Mar);

This example produces the following report:


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

See Also

@MINSRANGE
@MIN
@MAXSRANGE


Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.