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:

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 accounts 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:

#StDel# - average number of employees in a specific year.

Example:

Formulas can be tested in financial reports (Settings, Financials, Financial Report), where it is. In the lower windows of financial report template click the sign :

It opens a window wherewith the column Value. We enter value in this field for each variable and check the result.

For general information on testing formulas see Verification and Modification of Formulas.