Find the minimum value for a column or group.
field (required) The column to be searched. The function will search Numbers, Dates, and Strings, returning the minimum value.
NOTE: Sort order is affected by your database settings. For strings, 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.
- Finds the smallest balance. Could be negative.
- Finds the first name alphabetically. If Name was “Betty”, “Charles” and “Anne”, the result would be”Anne”
- Finds the lowest Invoice Date, which is the invoice date furthest in the past.
More About Aggregate Functions
If the column being aggregated is grouped, then the aggregate is computed for each group. For example, if the worksheet is grouped by the column [Year], then placing Sum([Revenue]) on the [Year] level computes the revenue for each year.
The results of aggregate functions can be referenced by lower levels. An example would be to create a Sum([Amount]) column as Total and then an [Amount] / [Total] column as Percentage. This converts each Amount value into a relative percentage value.