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.
-
Numeric function name:
MIN_NUM_ELEMENTS()
Syntax
MIN_NUM_ELEMENTS(column)
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.
Parameters
| Parameter | Description |
|---|---|
column |
The column containing one or more numeric values. Can be a Link to another table column or a Linked Table Column. |
Example
MIN_NUM_ELEMENTS($Linked Amounts)
The column returns the smallest value among the linked amounts.
Note: 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.
Return Type
The function returns a number (the smallest 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
MIN_NUM_ELEMENTS() identifies the lowest value in a linked set: smallest amount in a series of orders, lowest grade in a batch of evaluations.
Best Practice
Combine MIN_NUM_ELEMENTS() and MAX_NUM_ELEMENTS() to determine the range (spread) of a set of values.