The Min function finds the minimum value for a column or group.

Usage

Min(field)

Function arguments:

  • field (required) The column to be searched. Can be of type Number, Date, and String.

📘

The minimum of strings is determined by sort order, which is affected by your database settings. Sort order is most often blank spaces > special characters > numbers > uppercase letters > lowercase letters.
For numbers, preceding and trailing zeroes most often have no effect on sort order.

Example

Min(\[Balance\])

  • Finds the smallest balance. Could be negative.

Min(\[Name\])

  • Finds the first name alphabetically. If Name was “Betty”, “Charles”, and “Anne”, the result would be ”Anne”.

Min(\[Invoice Date\])

  • Finds the lowest Invoice Date, which is the invoice date furthest in the past.

Related resources