MIN
Category: Math & numeric
Overview
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.
Syntax
MIN('Node1', 'Node2')
Example usage: MIN('Revenue', 1000)
Parameters
| Parameter | Description | Type | Required |
|---|---|---|---|
| Node1 | First input, specified using the node name in single quotes (e.g.'Revenue') or a number | Node reference or number | Yes |
| Node2 | Second input, specified using the node name in single quotes (e.g.'Threshold') or a number | Node reference or number | Yes |
Output Shape
| Aspect | Behavior |
|---|---|
| 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
- If both inputs have levels, they must have the same dimensionality. Unlike multiplication or division, MIN does not perform dimension union or intersection.
- One input can be a constant number (e.g.
0,100). In that case, the constant is compared against every row of the other input.
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
| Year | Value |
|---|---|
| 2025 | 32 |
| 2026 | -42 |
| 2027 | -17 |
Input node: B
| Year | Value |
|---|---|
| 2025 | 41 |
| 2026 | 12 |
| 2027 | -25 |
Formula: MIN('A', 'B')
| Year | → MIN Result |
|---|---|
| 2025 | 32 |
| 2026 | -42 |
| 2027 | -25 |
Formula: MIN('A', 12)
| Year | → MIN Result |
|---|---|
| 2025 | 12 |
| 2026 | -42 |
| 2027 | -17 |
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
| Year | Value |
|---|---|
| 2025 | 0.05 |
| 2026 | 0.12 |
| 2027 | 0.08 |
| 2028 | 0.25 |
Formula: MIN('Discount Rate', 0.15)
| Year | -> MIN Result |
|---|---|
| 2025 | 0.05 |
| 2026 | 0.12 |
| 2027 | 0.08 |
| 2028 | 0.15 |
Values above 15% are capped at 0.15. Values already below the threshold are kept as-is.
Related Functions
| Function | When to use instead |
|---|---|
| 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. |