MAX_NUM_ELEMENTS() : find the largest value (among linked elements)

In a formula-type column, the MAX_NUM_ELEMENTS function returns the highest numeric value among the values in a column, including columns containing multiple values, such as fields of type Linked Table Column. 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 be added within quotation marks.
do not use quotation marks for numbers.

Syntax

MAX_NUM_ELEMENTS(column)

Parameters

# Parameter Description

1 column The column containing one or more numeric values. Can be a Link to another table column or a Linked Table Column type.

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 largest linked amount

The column returns the highest value among the linked amounts.

MAX_NUM_ELEMENTS($Linked Amounts)

Result of MAX_NUM_ELEMENTS on linked amounts

I can display the highest value among columns of number type, but also of text type provided they contain only numeric values. However, to avoid input errors, it is recommended to use number-type columns.

Go further

MIN_NUM_ELEMENTS

Combine both functions to frame a range of values.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.