The Apply Percentage Change calculation allows you to apply a specified percentage change to current values for the selected cell(s).
This operation may be applied to units, ASPs and/or values.
To apply a percentage change:
- Select Data > Apply Calculations from the tool-bar
- Select the Apply Percentage Change option
- Enter the required percentage change (positive or negative), e.g. 10 (do not enter a % sign)
- Click Apply
- 10% will then be calculated based on the selected cell and then this is added to the selected cells as shown above.
Amending Large Groups of Items
When you intend to apply the same percentage change operation to a large group of items, it is much quicker and more convenient to select items without sub-totals, e.g. in a sales database use the control key to select the item code and grand total levels.
Please sign in to leave a comment.