ROLLFORWARD_MUL

Basic Overview

Description	Rolls the values of OriginalNode forward with the influence of Node1 and other optional Nodes. The rollforward starts after the last value along the finest time level and is done for each shared dimension individually. If Node is not of type percent, the percentage-wise differences are calculated relative to the first value of the Node. Both nodes need to have the time dimension available. The dimensions of OriginalNode are retained and determine the dimensionality of the result. Node1 is rolled up according to its aggregation function to match the dimensions of OriginalNode. The difference between this function and ROLLFORWARD is how they treat multiple influence nodes. ROLLFORWARD sums up the effects and then applies them to the OriginalNode. ROLLFORWARD_MUL multiplies up the effects and then applies them to the OriginalNode
Signature	ROLLFORWARD_MUL('OriginalNode' [, 'Node1', …])
Parameters	OriginalNode: Input node, specified using the node name in single quotes (e.g. 'Revenue') Node1: Input node, specified using the node name in single quotes (e.g. 'Revenue')
Available since	3.9.0

Revenue =

Price Change (Unit:Percent) =

Year	Change in %
2021	10%

Volume Change (Unit:Percent) =

Year	Country	Value in %
2021	DE	10%
2021	FR	20%

Output ROLLFORWARD_MUL('Revenue', 'Price Change', 'Volume Change')

For more examples look at ROLLFORWARD function documentation. Keep in mind the difference in how the functions treat multiple influence parameters.

You may contact the Valsight Customer Support via:

+49 30 46799042

Availability: Mon-Fri *, 9 AM to 5 PM (Berlin, Germany) .

_{*Except Public holidays in Berlin, Germany.}