The Apply Percentage Growth calculation allows you to apply a specified monthly % growth rate to values for the selected cells using the previous period as a base.
To apply a percentage growth:
- Select the range of cells to be amended (this option is not available for periods starting with January as otherwise no base period will be available)
- Select Data > Apply Calculations from the tool-bar.
- Select the Apply Percentage Growth calculation option from the drop down list.
- Enter the required percentage growth (positive or negative),e.g. 10. Do not enter a % sign.
- Click Apply.