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