In a formula-type column, the MAX() function returns the largest value among several columns or numeric values.
-
Numeric function name:
MAX()
Syntax
MAX(column_1, column_2, ...)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
column_1, column_2, ... |
Number-type columns and/or values to compare. |
Example
MAX($Offer A, $Offer B, $Offer C)
The column returns the highest offer among the three.
I selected the largest numeric value contained in my Provider 1, Provider 2, and Provider 3 columns to find out which was the most expensive.
Return type
The function returns a number (the largest value).
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business use case
MAX() retains the largest value: best offer, upper limit of a range, highest rating.
Best practice
For the maximum among values in a single column of a linked table, use MAX_NUM_ELEMENTS().