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.

You 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. Data dictionary Compute statement

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