Fixed Value
Description
The Fixed Value function overwrites the value of a business figure with an absolute amount. This amount can be the value of another business figure, which itself can be adjusted using the basic arithmetic operations.
Using this Function
Syntax
In the Control File, the Fixed Value function is called up as follows:
[account] = value
[account] = (value1, ..., valueN)
[account] = [referenceAccount] operator value
Parameters
[account]
Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data
value
Denotes the absolute amount with which the old value of the business figure is to be overwritten.
(value1, value2, ..., valueN)
Denotes a list of absolute amounts with which the old value of the business figure is to be overwritten.
Here, value1 is used for the first calculation date, value2 for the second calculation date, etc.
operator
Stands for one of the basic arithmetic operations +, -, *, /.
[referenceAccount]
Denotes the business figure whose value is to be used for overwriting.
This must be contained in the following input data: Input Files | Financial-Data
Examples
The examples below are based on the following data:
value of the business figure [10003]: 47,600.00
value of the business figure [10003]: 12,400.00
Example 1
[10003] = 50000
new value of the business figure [10003]: 50,000.00
Example 2
[10003] = (50000, 51000, 52000)
new value of the business figure [10003] on the first calculation date: 50,000.00
new value of the business figure [10003] on the second calculation date: 51,000.00
new value of the business figure [10003] on the third calculation date: 52,000.00
Example 3
[10005] = [10003] * 0.3
new value of the business figure [10005]: 47,600.00 * 0.3 = 14,280.00