Min

Returns the minimum of values found in the tuples of a set.

Syntax

Min ( set [,numeric_value_expression ] )

set The set to search for values.
numeric_value_expression Optional numeric value expression.

Description

The return value of Min is #MISSING if either of the following is true:

Example

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