The @MINRANGE() function returns the minimum value of mbrName across rangeList.
@MINRANGE (mbrName [ ,rangeList])
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
rangeList | Optional. 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. |
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.
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
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.