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.
Updated 3 months ago
Related resources