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:
| SymbolValue1 | SymbolValue2 | Growth Rate Percentage |
|---|---|---|
100 |
95 |
-5 |
95 |
112 |
17.8947 |
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.
Syntax example:
GROWTH (A41000)
See also