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