The Total Calculation row is intended to build formula from existing rows. Calculation, Hidden, Cash Flow Activity and another Total Calculation rows can be used to build the formula.
Follow these steps to add a Total Calculation row.
- Add a new row .
- Enter a value in the Description field. This value should be as descriptive as possible so it would be easy to read what row is that for.
- In the Row Type field, select Total Calculation.
- Place your cursor in the Related Rows field and you will see an ellipsis button. Click that button and Row Calculation screen will open. See How to Configure formula for Total Calculation row to guide you on how to build your formula.
- Leave out Balance Side field.
- Leave out Filter Accounts field.
This is how Total Calculation row will look like when you follow the above steps.
This is how it will be shown when you print your financial report. The balances shown per column is the sum of Row 13 - Sales and Revenues and Row 14 - COGS and Expenses rows.
You can enhance this row by setting its Font Properties and Row Height. See How to Configure Row font properties and row height topic to guide you on how to do this.
Overview
Content Tools