Sum
Description
The Sum function calculates the value of a business figure as the sum of values of other business figures.
Using this Function
Syntax
In the Control File, the Sum function is called up as follows:
[account] = sum [referenceAccount_A] to [referenceAccount_N]Parameters
[account]
Business figure for which the value should be calculated.
This must be contained in the following input data: Input Files | Financial-Data
[referenceAccount_A]
Denotes the business figure from which the sum of the values is to be calculated (according to the order of the business figures in the Input Files | Financial-Data).
[referenceAccount_N]
Denotes the business figure up to which the sum of the values is to be calculated (according to the order of the business figures in the Input Files | Financial-Data).
Examples
The examples below are based on the following data, which is contained in the Input Files | Financial-Data in this order.
Balance sheet position | Account number | 31/12/2023 |
|---|---|---|
Balance sheet position A | 102 | 2,000.00 |
Balance sheet position B | 101 | 1,000.00 |
Balance sheet position C | 1021 | 500.00 |
Balance sheet position D | 103 | -3,000.00 |
Balance sheet position E | 600 | 7,000.00 |
Balance sheet position F | 500 | 2,500.00 |
Balance sheet position G | 300 | 2,000.00 |
Balance sheet position H | 400 | 3,000.00 |
Example 1
[80000] = sum [101] to [500]new value of the business figure [80000]: 1,000.00 + 500.00 - 3,000.00 + 7,000.00 + 2,500.00 = 8,000.00
Example 2
[80000] = sum [600] to [300]new value of the business figure [80000]: 7,000.00 + 2,500.00 + 2,000.00 = 11,500.00