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