Report Formulas

Report Formulas enable the calculation of key ratios and indicators.

By using the Calculate Report Formulas menu, you can perform a calculation in a report and save the result in the database like ordinary account information. User-defined reports can be used for the presentation of data generated as a result of report formulas.

The following menu commands are used when working with report formulas:

Reports/Create and Go to Layout in Excel
Group/Calculate Report Formulas

You use this function to create a calculation account where you want to store the calculated value in the database. The account must be a statistical account, which means that only account types R, S, T and U can be selected. When you create a Calculation Report you have to define the axes as in a normal report. In the layout in Microsoft Excel you can, based on the data in the data area, define your own ratio calculations.