The ROLLFORWARD calculates growth individually per driver, so, for example if you have 2% Inflation and 10 % percent growth it will add exactly 12% to the base value. If you instead want to define, that these effects are already influencing each other in the respective year, you can use this pattern.

To illustrate the difference, consider the following comparison:

2018

2019

2020

Base Value

100

Inflation

2%

3%

Growth

10%

11%

ROLLFORWARD('Base Value','Inflation,'Growth')

=100 + (100 * 0.02) + (100 * 0.1) = 112

=112 + (112 * 0.03) + (112 * 0.11) = 127.68

ROLLFORWARD('Base Value','Combined Growth')

= 100 * 1.02 * 1.1 = 112.2

= 112.2 * 1.03 * 1.11 = 128.27

To build models with the combined growth, use the following formula in a separate node.

Combined Growth =
ADDEACH(
   IF(IS_NA('Inflation'), 1.0 , ADDEACH('Inflation',1))
*  IF(IS_NA('Growth'), 1.0 , ADDEACH('Growth',1))
* (More Influencers)
,-1)
CODE

The 'Combined Growth' node must use the unit 'Percent'

And then use this helper node in the ROLLFORWARD function:

ROLLFORWARD('Base Value','Combined Growth')


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.