Growth

Use this function to calculate the growth rate percentage of a series of values.

For each symbol in the BY dimension, growth is calculated as:

[(symbolvalue1 - symbolvalue2) / symbolvalue1(-1)] "*" 100        

Consider the following two examples of symbol values and the resulting calculated growth rate percentages:

This function must be used in conjunction with the BY function, typically using the time periods dimension.

Syntax

GROWTH (SymName)        

where:

• SymName is the name of the source symbol in the calculation dimension.

GROWTH (A41000)                

See also

• Using conditional operators
• By
• Operators (relational)
• When...