---
url: /technical/dataspreading-set.md
description: Sets the cell intersection to the input number.
---

# /set

Sets the cell intersection to the input number.

If the cell is a consolidation intersection, slices to the populated child cells and proportionately sets the child cell value based on the input number.

Proportion is based on the following:

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

### Parameters

```js
/set inputNumber
```

`inputNumber` - the number amount to set the cell intersection to.

### Examples

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

* 3/4 of the `inputNumber` of 2000 was set to the `Direct Cost of Goods` cell.
* 1/4 of the `inputNumber` of 2000 was set to the `Indirect Cost of Goods` cell.

### Example Hierarchy Used

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

::: info

* `/set` does not work on string measures.
* `/set` does not work if the cell or descendant cells are equal to 0.
* `/set` does not correctly set the `inputNumber` to 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.
  :::