Description
The MIN function returns the smallest value among the specified numbers.
Usage
This function is used to find the minimum value from a list of numbers.
Syntax:MIN(number1, [number2], …)
Examples
-
Find the Smallest Value in a Field:
MIN(#[Exceptions].[Duration])Returns the minimum value from the Duration field in the linked Exceptions records.
-
Find the Minimum Asset Cost for Active Assets:
MIN(FILTER(#[Assets].[Asset Cost], #[Assets].[State] = "Active"))Returns the minimum value from the Asset Cost field in the linked Assets records, where the State is "Active."
Inputs
| Argument | Data Type | Description |
|---|---|---|
| number1 | Number / Number Array | The first number to compare. |
| [number2] | Number / Number Array | (Optional) Additional numbers to compare. |
Returns
Type: Number
- Produces the smallest value from the specified list of numbers.