# 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

## Example

Revenue =

 Year Country Revenue 2020 DE 100 2020 US 100

As you can see, the “Revenue” node contains our base data for the countries US and DE.

Price Change (%) =

 Year Change in % 2021 10%

The “Price Change” node contains a 10% change without any country-level values.

Volume Change (%) =

Year

Country

Value in %

2021

DE

10%

2021

FR

20%

The “Volume Change” node contains 10% and 20% changes; note that the 20% change is for the country “FR”, which was not present in the base node “Revenue”.

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

Year

Country

Value

2020

DE

100

2020

US

100

2021

DE

100 * ( (0.1 + 1) * (0.1 + 1) ) = 121

2021

US

100 * (0.1 + 1) = 110

This chart displays the calculation logic and results when using ROLLFORWARD_MUL with the previous nodes.

As you can see, both countries (DE & US) received a 10% growth from the level-less “Price Change” node. Additionally, this 10% growth was multiplied by another 110% of the base value in the case of DE, which is due to the “Volume Change” node.

The key aspect of ROLLFORWARD_MUL is visible in this 2021 DE value; the two 10% growths are first multiplied (1.1 * 1.1) and then applied to the base value (100 * 1.21).

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

JavaScript errors detected