MIN

In Math & numeric

The MIN function returns the minimum of matching values from two inputs. Both inputs must have either the same dimensionality or one input must be a number, in which case the result has the dimensionality of the other input.

Use this function when you need the row-wise minimum of two nodes or when you want to apply an upper threshold (cap) to a node: MIN('Revenue', 1000).

Parameters

Node1Node reference or numberRequired

First input, specified using the node name in single quotes (e.g.'Revenue') or a number

Node2Node reference or numberRequired

Second input, specified using the node name in single quotes (e.g.'Threshold') or a number

Output shape

Dimensionality

Same as the input with levels. If one input is a constant (number), the result has the dimensionality of the other input.

Values

For each matching row, the lower of the two values is returned.

Row count

Same as input.

Watch out

Examples

Row-wise minimum across two inputs

This example shows MIN applied both to two input nodes and to a node combined with a fixed numeric threshold.

Input node: 'A'

Input node: 'B'

Formula: MIN('A', 'B')

Formula: MIN('A', 12)

Using MIN as a cap (clamp values to an upper limit)

A common pattern: use MIN('Node', threshold) to ensure no value exceeds a defined maximum.

Input node: 'Discount Rate'

Formula: MIN('Discount Rate', 0.15)

Values above 15% are capped at 0.15. Values already below the threshold are kept as-is.

See also

MAX

When you need the row-wise maximum of two nodes or thresholds instead of the minimum.

ABS

When you need absolute values of one node rather than a comparison between two inputs.