DIVISION (/)

Overview

Description

Divides nodes by performing a join along the shared levels of the nodes (dimension union). The result has all the finest levels that are present in either of the nodes.

Use when you want standard division across shared levels without additional validation handling.

Syntax

'Node1' / 'Node2'

Parameters

Node1: Dividend node, specified using the node name in single quotes, for example 'Profit'.
Node2: Divisor node, specified using the node name in single quotes, for example 'Profit'.

Examples

All shared dimensions

This example shows the basic case where both inputs share the same dimensions. The division is performed row by row on matching intersections.

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

Some shared dimensions

This example shows how division works when one input has additional dimensions. The shared level values are matched first, then the finer dimension from Node1 is retained in the result.

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 / 4 = 0
2026	A	4 / 4 = 1
2026	B	16 / 4 = 4

Without shared dimensions

This example shows the case where the second input has no shared dimension except a single constant value. That value is applied across all matching rows of the first 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 dimension-union behavior of standard division.