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