Min (minimum)

Min returns the lowest value in a list of values. For example, it can be used on a list of prices to determine the minimum cost of an item. This is a group-value function.

To compare the lowest values in multiple lists of values, use the Least function.

Syntax

Min <FactID, NullInclude>(Argument)

Where:

• Argument is an attribute, fact, or metric representing a list of numbers.
• FactID is a parameter that forces a calculation to take place on a fact table that contains the selected fact.
• NullInclude is a parameter that determines how NULL values are included in the calculation.

Example

This example shows a report displaying the cost range of items within a subcategory. The Min function is used to determine the lowest cost of an item within a subcategory. The metric Minimum Unit Cost is defined as follows:

Minimum([Unit Cost]) {~}

The metric is placed on a report with the attributes Category and Subcategory and the metric Maximum Unit Cost.