DIVISION (/)
Category: Arithmetic operators
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 exampleIF('Divisor' != 0, 'Dividend' / 'Divisor', 0). - Units are divided together as well. For example,
EUR/Quantityproduces the combined unitEUR / 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. |