Relative Adjustment
Description
The Relative Adjustment function increases or decreases the value of a business figure by a relative amount.
Using this Function
Syntax
In the Control File, the Relative Adjustment function is called up as follows:
[account] operator value
[account] operator (value1, value2, ..., valueN)
Parameters
[account]
Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data
operator
Stands for one of the basic arithmetic operations + or -.
value
Denotes the relative amount by which the old value of the account is to be increased or decreased according to the calculation type of ‘operator’.
The relative amount must be a percentage value.
(value1, value2, ..., valueN)
Denotes a list of relative amounts by which the old value of the business figure is to be increased or decreased according to the calculation type of ‘operator’.
Value1 is used for the first calculation date, value2 for the second calculation date and so on.
All relative amounts must be percentage values.
Examples
The examples below are based on the following data:
value of the business figure [10003]: 47,600.00
Example 1
[10003] + 5%
new value of the business figure [10003]: 47,600.00 * 1.05 = 49.980,00
Example 2
[10005] - 10%
new value of the business figure [10003]: 47,600.00 * 0.9 = 42,840.00
Example 3
[10005] - (50%, 50%, 20%)
new value of the business figure [10003] on the first calculation date: 47,600.00 * 0.5 = 23,800.00
new value of the business figure [10003] on the second calculation date: 23,800.00 * 0.5 = 11,900.00
new value of the business figure [10003] on the third calculation date 11,900.00 * 0.8 = 9,520.00