Total names

A total name is used to obtain account and accounting unit balances for use in compute statements or ratios. You can define a total name to identify any combination of accounting unit, account, or subaccount balances for a company, company group, level group, accounting unit list, or total range as if they were one amount. Defining a total name is important because you cannot use account or accounting unit ranges in a compute statement. For example, you can assign the name SALES to group sales accounts so that you can use the total value of sales in a calculation.

You can use the total names that you define in the Allocations, Budgeting, Ratio Analysis, Project Accounting, Lease Management applications.

Note: You must define a total name before using it in a compute statement.

Use a total name in a compute statement with a data dictionary name that has a TOT suffix. For example, if you create a SALES total name and you want to include the current period total for it in a compute statement, then the data dictionary name is CPTOT(SALES). CP identifies the current period, TOT identifies that a total name is specified, and SALES is the total name.

See these topics:

You can select the amount, unit, currency, or budget values to create the total.