MAX

In Math & numeric

The MAX function returns the maximum 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 maximum of two nodes or when you want to apply a lower threshold (floor) to a node: MAX('Revenue', 0).

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 higher of the two values is returned.

Row count

Same as input.

Watch out

Examples

Row-wise maximum across two inputs

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

Input node: 'A'

Input node: 'B'

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

Formula: MAX('A', 7)

Using MAX as a floor (clamp negative values to zero)

A common pattern: use MAX('Node', 0) to ensure no negative values appear in the result.

Input node: 'Margin'

Formula: MAX('Margin', 0)

Negative margins are replaced with 0. Positive margins are kept as-is.

See also

MIN

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

ABS

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