@MINRANGE
The @MINRANGE calculation function for Essbase returns the minimum value of a member across a range of members.
This function returns the minimum value of mbrName across XrangeList.
Syntax
@MINRANGE (mbrName [ ,XrangeList])
Parameters
- mbrName
-
Any valid single member name, or a function that returns a single member.
- XrangeList
-
Optional. A valid member name, a comma-delimited list of member names, cross dimension members, or a member set function or range function (including @XRANGE) that returns a list of members from the same dimension. If XrangeList is not specified, Essbase uses the level 0 members from the dimension tagged as Time.
Notes
Depending on the values in the list, this function may return a zero(0) or #MISSING
value. For full control over skipping or inclusion of empty values, use @MINSRANGE.
Example
In the Sample Basic database:
Qtr1 = @MINRANGE(Sales,Jan:Mar);
produces the following report:
Colas New York Actual
Jan Feb Mar Qtr1
=== === === ====
Sales 678 645 675 645
See Also