Growth

See also: GrowthAs, GrowthFromValue, GrowthFromYear

Syntaxes

Growth(Expression ) or
Growth(Expression1, Year2, Expression2) or
Growth(Expression1, Year2, Expression2, Year3, Expression3) or
Growth(Expression1, Year2, Expression2, Year3, Expression3, Year4, Expression4) or
Growth(Expression1, Year2, Expression2, Year3, Expression3, Year4, Expression4, Year5, Expression5)

Description

Calculates a value in any given year using a growth rate from the base year value. Because it references the base year value, this function is only available when editing scenarios. You can specify a single growth rate or using the alternative syntaxes, you can specify up to 5 periods with different growth rates. For example, from Year2 onwards the growth rate will be Expression2 and from Year3 onwards the growth rate will be Expression3.

Specify decreases using negative values for the growth rate.

Example

Growth(0.05) or Growth(5%)

This expression, entered in a scenario, causes the variable to grow at 5% per year through all of the scenario years, starting from the value in the year before the first scenario year.  

Consider a case with an area where the Base Year is 2000 and the base year variable value is set of 100.  In this case the above expression yields the following results:

2001 = 105.00
2002 = 110.25

NB: Take care when applying a growth rate over a long period as values can grow very large!

Growth(5%, 2015, 2%)

In this example, the variable again initially grows at 5% per year.  However, from 2015 onwards the variable grows at only 2% per year.