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