Understanding the Subtotal Row Definition Type

Tutorial (Release 9.2 Update): Click here to view a recording of this feature.

You can use the subtotal row definition type to provide totals for one or more sections in a financial statement. When you set up a subtotal row definition, you specify the title that you want to use for the subtotal line. The system uses the title as the name of the section in the statement definition; however, you can change the name to reflect the purpose of the subtotal row definition. For example, if you use a subtotal row definition to provide a total of revenues and direct costs, you might change the name of the section in which you use the subtotal row definition to Gross Margin.

When you use the subtotal row definition in a statement definition, you specify the range of sections in the statement definition to include in the subtotal. The system will calculate subtotals for the account balances in each column in the statement definition section based on the subtotal row definition.

You can set up just one or two subtotal row definitions and then use them whenever you need to include a subtotal row in a financial statement. For example, you might set up a subtotal row definition that will reverse the sign of the account balances, and another subtotal row definition that will not reverse the sign of the balances, and then use those subtotal row definitions in multiple statement definitions and multiple sections within a statement definition. If a section that you include in the subtotal contains a row marked for sign reversal, the system calculates the subtotal prior to the reversing the sign for the balances retrieved for that row.

You also have an option in the statement definition to include or exclude subtotal sections that fall within the range of sections specified for the subtotal section. By default, the system does not include subtotal sections that are within the range of sections that you specify for a subtotal section.