# DIVISION (/)
URL: https://docs.valsight.ai/division/
Description: The DIVISION operator divides one input by another across their combined dimension set. In other words, division uses the union of both inputs’ dimensions.
**Category:** [Arithmetic operators](/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 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 | Calculation | 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 | Calculation | 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 | Calculation | Result |
| ---- | ----------- | ------ |
| 2025 | 4 / 2       | 2      |
| 2026 | 8 / 2       | 4      |

## Related

| Function           | When to use instead                                                                                            |
| ------------------ | -------------------------------------------------------------------------------------------------------------- |
| [DIVIDE](/divide/) | When you want the same basic division result but with optional mismatch validation and clearer error messages. |
| [RATIO](/ratio/)   | When only the dimensions shared by both inputs should be retained instead of using the combined dimension set. |