MAX() : find the largest value

In a formula-type column, the MAX function returns the largest value among several columns or numeric values. It returns a number.

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.

Syntax

MAX(column_1, column_2, ...)

Parameters

# Parameter Description

1 column_1, column_2, ... Number-type columns and/or values to compare.

The output format of the result (number, currency, percentage...) is configured in the output field options of the formula editor. See Output format options in the Formula Column article.

Examples

Find the highest offer

The column returns the highest offer among the three.

MAX($Offer A, $Offer B, $Offer C)

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.

Go further

MAX_NUM_ELEMENTS

For the maximum among the values of a single column in a linked table.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.