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