DIVISION (/)

Overview

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.

Syntax

'Node1' / 'Node2'

Example usage: 'Profit' / 'Revenue'

Parameters

Parameter	Description	Type	Required
Node1	Dividend node, specified using the node name in single quotes (e.g.`'Profit'`)	Node reference	Yes
Node2	Divisor node, specified using the node name in single quotes (e.g.`'Revenue'`)	Node reference	Yes

Output Shape

Aspect	Behavior
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

Division uses the combined dimension set (union), not the common dimensions. This is the opposite of addition and subtraction.
If one input has additional dimensions, the result expands to keep them.
Division by zero returns N/A.
If you need explicit fallback handling, wrap the division in an IF(...) condition, for example IF('Divisor' != 0, 'Dividend' / 'Divisor', 0).
Units are divided together as well. For example, EUR / Quantity produces the combined unit EUR / Quantity.

Examples

Dividing nodes with matching dimensions

Input node: Node1

Year	Value
2025	6
2026	4

Input node: Node2

Year	Value
2025	3
2026	1

Formula: 'Node1' / 'Node2'

Year	→ DIVISION Result
2025	6 / 3 = 2
2026	4 / 1 = 4

Dividing nodes with some shared dimensions

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

Input node: Node1

Year	Product	Value
2025	A	4
2025	B	0
2026	A	4
2026	B	16

Input node: Node2

Year	Value
2025	2
2026	4

Formula: 'Node1' / 'Node2'

Year	Product	→ DIVISION Result
2025	A	4 / 2 = 2
2025	B	0 / 2 = 0
2026	A	4 / 4 = 1
2026	B	16 / 4 = 4

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

Year	Value
2025	4
2026	8

Input node: Node2

Value
2

Formula: 'Node1' / 'Node2'

Year	→ DIVISION Result
2025	4 / 2 = 2
2026	8 / 2 = 4

Related Functions

Function	When to use instead
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.