MODLR/subtract
subtracts the input number from the cell intersection.
If the cell is a consolidation intersection, slices to the populated child cells and proportionately subtracts from the child cell value.
Proportion is based on the following:
js
childCellValue/sumOfAllChildCellValues * inputNumberchildCellValue/sumOfAllChildCellValues * inputNumberParameters
js
/subtract inputNumber/subtract inputNumberinputNumber - the number amount to be subtracted from the cell intersection.
Examples
Before /subtract
After /subtract
- 2/3 of the
inputNumberof 300 was subtracted fromDirect Revenuecell. - 1/3 of the
inputNumberof 300 was subtracted from theDirect Cost of Goodscell.
Example Hierarchy Used
INFO
/subtractdoes not work on string measures./subtractdoes not work if the cell or descendant cells are equal to 0./subtractdoes not correctly subtract theinputNumberfrom 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.