Returns the maximum value of the specified member across the specified range of members.
Syntax
@MAXRANGE (mbrName [ ,XrangeList])
Parameter | Description |
---|---|
mbrName | Any valid single member name or member combination, or a function that returns a single member or member combination. |
XrangeList | 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, @MAXRANGE 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 @MAXSRANGE instead of @MAXRANGE.
Example
In the Sample Basic database:
Qtr1 = @MAXRANGE(Sales,@CHILDREN(Qtr1));
produces the following report:
Colas New York Actual Jan Feb Mar Qtr1 === === === ==== Sales 678 645 675 678
See Also