Verifying Formulas in Financial Reports
Verifying Formulas in Financial Reports |
|
|
When verifying formulas used in financial reports
(see Formula Verification) besides formula
regularity checks also whether it is possible to enter such an expression. This
is in further detail described in the Financial Report
Formulas.
Any expression, which is not followed by the next combination of characters,
is incorrect:
| In initial position |
Followed by |
|
D – debit transactions on account ina given period
K – credit transactions on account in a given
period
S – absolute value of account balance in a given
period = |D - C|
P - credit – debit (credit balance in a given
period) = C - D
O – debit – credit (debit balance in a given period)
= D - C
|
any set of characters identifying the account for example:
11%
|
|
A - value in line under column A (Formula 1)
B - value in line under column B (Formula 2)
|
any line number for example.:
10
Here it is wise to use integers only, on the other hand you cannot use
wildcard characters.
Otherwise when testing formula, the following error is returned (see
Line number must be integers (#xx#)!). |
|
EmpNo - average number of employees in an individual year.
|
(no record) |
If one of the four characters that can be found under the first column is not
used in initial formula position, the following error is returned when running
test (see The first character of %s must be a
transaction type or a column mark!).
Below You Can See Examples of Correct Entry:
For accounts and account groups:
- #S1200# = balance of account 1200 in a given period (absolute
balance)
- #D12%# = debit transactions on accounts of group 12 in a given
period
- #K0%# = credit transactions on accounts of class 0 in a given
period
- #O02%# = debit – credit on accounts of group 02 in a given period
(debit balance) = #D02%#-#K02%#
- #P90%# = credit – debit on accoutns of group 90 in a given period
(credit balance) = #K90%#-#D90%#
as well as for lines:
- #A1# - value in line 1 from column A (Formula 1)
- #B14# - value in line 14 from column B (Formula 2)
for average number of employees in a specific year:
Empno - average number of employees in a specific year.