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

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')

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

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


FAQs

Frequently asked questions can be found here

Contact 

You may contact the Valsight Customer Support via:

+49 30 46799042

support@valsight.com

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

*Except Public holidays in Berlin, Germany.