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

Last updated