CURRENT_NODE_VALUES
The CURRENT_NODE_VALUES function returns the node's current period value.
Example
Consider a scenario where you want to assign 1000 as the first month's Sales value and want the subsequent periods to have a month-on-month growth of 10%.
To achieve this, the following formula should be written in the [Sales] node:
IF(CURRENT_PERIOD_INDEX==1,1000,CURRENT_NODE_VALUES.GET(CURRENT_PERIOD_INDEX-1)*1.1)
Result
| Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Sales | 1000 | 1100 | 1210 | 1331 | 1464 | 1611 | 1772 | 1949 | 2144 | 2358 | 2594 | 2853 |
Last updated