Returns the minimum of values found in the tuples of a set.
Min ( set [,numeric_value_expression ] )
set | The set to search for values. |
numeric_value_expression | Optional numeric value expression. |
The return value of Min is #MISSING if either of the following is true:
For every quarter, the following query displays the minimum monthly sales value.
WITH MEMBER [Measures].[Minimum Sales in Quarter] AS 'Min ([Year].CurrentMember.Children, [Measures].[Sales])' SELECT {[Measures].[Minimum Sales in Quarter]} ON COLUMNS, [Year].Children ON ROWS FROM Sample.Basic
This query returns the grid:
Minimum Sales in Quarter | |
---|---|
Qtr1 | 31538 |
Qtr2 | 32917 |
Qtr3 | 33073 |
Qtr4 | 31971 |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |