Certain subtotal lines on the financial statement lines do not consist only of the addition or subtraction of main groups. Certain lines within the groups may be excluded from the arithmetic operations, or multiplied with a factor before inclusion. Likewise, certain account lines of a sub-group may have to be included. In such complex cases, group or subtotal definitions do not solve the problem. Formula definitions that indicate which table lines will be included and how they will affect the line total.
The formula line is always independent from groups. Which means, it is not the sub-line of a group. Furthermore, it is also not processed in the calculation of Subtotal and Grand Total information located in subsequent lines. Therefore, the definition code information is not necessary. (The description would be enough.)
The amount of the Formula line is calculated using the information entered into the Formula definition field. The following information is recorded using the formula option.
Description: The description to be displayed on the formula line of table reports in entered on this field.
Formula Definition: The amount to be displayed next to the formula line description is used as a variable in the formula by adding a “P” (the first letter of Parameter) on table lines. Aggregation, subtraction, multiplication and division operations with fixed numbers can be performed between variables. (as in the calculations on discount and expense cards.)
For example, let’s assume that the amounts of two lines with definition codes 12 and 45 are 50 TRY and 100 TRY respectively. If the formula line is required to calculate half the total of these two lines, the expression to be inserted on the Formula Definition field is (P12 + P45) / 2. The application will calculate and enter the value 75 TRY next to this line on the table report.