Min

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

  1. Find the Smallest Value in a Field:

    MIN(#[Exceptions].[Duration])
    

    Returns the minimum value from the Duration field in the linked Exceptions records.

  2. 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.
Was this article helpful?
0 out of 0 found this helpful