MIN

Use MIN to insert the lowest value in a group of objects, such as a group of measures. This function has this syntax, in which arg1, arg2 represent the objects to use:

MIN(arg1, arg2...)

For example, assume these measure results:

The measure whose formula you are creating (represented by this): 35,000
Car Sales=40,000
Truck Sales=21,000

The formula inserts 21,000 since Truck Sales has the lowest result value.

To insert this function:

Select Functions , thenStatistical, and double-click MIN.
This inserts MIN(arg1, arg2...)
Delete arg1 and insert the function that retrieves the values to use.
For example, to find the lowest score achieved by a scorecard, insert sScore.
Select the object to use from the box.
Repeat steps 2 and 3 to define subsequent arguments.