---
url: /technical/dataspreading-add.md
description: Adds the input number to the cell intersection.
---

# /add

Adds the input number to the cell intersection.

If the cell is a consolidation intersection, slices to the populated child cells and proportionately adds to the child cell value.

Proportion is based on the following:

```js
childCellValue/sumOfAllChildCellValues * inputNumber
```

### Parameters

```js
/add inputNumber
```

`inputNumber` - the number amount to be added to the cell intersection.

### Examples

![Dataspreading Workview](/dataspreading-workview.png)
Before `/add`
![Dataspreading Workview](/dataspreading-add-before.png)
After `/add`
![Dataspreading Workview](/dataspreading-add-after.png)

* 2/3 of the `inputNumber` of 1000 was added to `Direct Revenue` cell.
* 1/3 of the `inputNumber` of 1000 was added to the `Direct Cost of Goods` cell.

### Example Hierarchy Used

![Dataspreading Hierarchy](/dataspreading-hierarchy.png)

::: info

* `/add` does not work on string measures.
* `/add` does not work if the cell or descendant cells are equal to 0.
* `/add` does not correctly add the `inputNumber` to the consolidation cell if the consolidation cell includes populated children where the value of the child will be flipped through the use of \[-1] element signage.
  :::