DIVISION (/)

In Arithmetic operators

The DIVISION operator divides one input by another across their combined dimension set. In other words, division uses the union of both inputs’ dimensions.

The result keeps the finer level in each shared dimension and retains dimensions that exist on only one side.

Use this operator for standard division without additional validation handling: 'Profit' / 'Revenue'.

Parameters

Node1Node referenceRequired

Dividend node, specified using the node name in single quotes (e.g.'Profit')

Node2Node referenceRequired

Divisor node, specified using the node name in single quotes (e.g.'Revenue')

Output shape

Dimensionality

The result uses the combined dimension set (the union of both inputs’ dimensions). Per shared dimension, the finer level is used. Dimensions that exist on only one side are kept as-is.

Level values

Values are matched on shared dimensions. Non-shared dimensions expand the result across matching rows.

Row count

Equal or expanded. Cells where the divisor is zero or missing become N/A.

Watch out

Examples

Dividing nodes with matching dimensions

Input node: 'Node1'

Input node: 'Node2'

Formula: 'Node1' / 'Node2'

Dividing nodes with some shared dimensions

This example shows how division keeps the finer dimensionality from Node1.

Input node: 'Node1'

Input node: 'Node2'

Formula: 'Node1' / 'Node2'

Dividing by a scalar

When one input is a scalar value, that value is applied across all rows of the other input.

Input node: 'Node1'

Input node: 'Node2'

Formula: 'Node1' / 'Node2'

See also

DIVIDE

When you want the same basic division result but with optional mismatch validation and clearer error messages.

RATIO

When only the dimensions shared by both inputs should be retained instead of using the combined dimension set.