MIN_NUM_ELEMENTS() : find the smallest value (among linked elements)

In a formula-type column, the MIN_NUM_ELEMENTS function returns the smallest numeric value among the values in a column, including columns containing multiple values, notably fields of the Linked Table Column type. 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 inside quotation marks.
do not use quotation marks for numbers.

Syntax

MIN_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.

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

The column returns the smallest value among the linked amounts.

MIN_NUM_ELEMENTS($Linked Amounts)

Result of MIN_NUM_ELEMENTS on linked amounts

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

Go further

MAX_NUM_ELEMENTS

Combine both functions to find the range of a set of values.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.