MODLR/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 * inputNumberchildCellValue/sumOfAllChildCellValues * inputNumberParameters
js
/set inputNumber/set inputNumberinputNumber - the number amount to set the cell intersection to.
Examples
Before /set
After /set
- 3/4 of the
inputNumberof 2000 was set to theDirect Cost of Goodscell. - 1/4 of the
inputNumberof 2000 was set to theIndirect Cost of Goodscell.
Example Hierarchy Used
INFO
/setdoes not work on string measures./setdoes not work if the cell or descendant cells are equal to 0./setdoes not correctly set theinputNumberto 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.