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. A row that exists in only one input keeps that input’s value.

Row count

The union of both inputs. A row present in only one of them is kept, not dropped.

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.

Related

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.