1. Calculation functions
  2. All Functions
  3. Numeric Functions
  4. MIN

Returns the minimum value in the selected line items.

It can also be used as an aggregation function, see x[MIN:y].

Syntax

MIN(x,y,[z]) 

where:

  • x: Number or date to compare
  • y: Number or date to compare

Format

Input Format Output Format

x: number or date

y: number or date

Matches the data format used by argument x

Arguments

The function uses the following arguments:

  • x: number-formatted or date-formatted line items
  • y: number-formatted or date-formatted line items

Constraints

The function has the following constraints:

  • At least two arguments must be passed.
  • The result formatting must match the source formatting.

Excel equivalent

Back to Top

Example

A number-formatted Minimum Monthly Costs result line item uses MIN against six number-formatted source line items:

A text-formatted Earliest Accounting Date result line item uses MIN against three date-formatted source line items:

Back to Top

Similar functions