Total name

Activity compute parameters apply to the activity-related data dictionary names in the compute statement. If you want to retrieve activity balances using different criteria than those specified in the compute parameters, then you can use a special total data dictionary name with a total name. A total name is a unique type of parameter that is used in place of compute parameters. You can use activity total names with these total data dictionary names:

Data dictionary name Description Parameters
LTDACT Life To Date Activity Total Total Name, Year, Period, Activity
PRDACT Period To Date Activity Total Total Name, Year, Period, Activity
YTDACT Year To Date Activity Total Total Name, Year, Period, Activity

Total names are useful when you want to include two data dictionary names that retrieve different activity information in the same compute statement.

Note: You can use General Ledger total names in compute statements for activity budgets or allocations. For more about General Ledger total names, see the Report Writer User Guide.

Example

LGE Corporation wants to base an allocation on the ratio of current period technician hours for the X-RAY activity to current period technician hours for all other imaging-related activities. They constructed this compute statement:

Illustration: Using a total name in a compute statement

The compute parameters are associated with the data dictionary name PRDACU (period-to-date activity units) in the numerator, so they selected the X-RAY activity and the Labor account category.

Because different activities should be associated with the denominator, they used the data dictionary name, PRDACT (period-to-date activity total) that accepts a total name (IMAGING). The total name identifies the other imaging-related activities they want to associate with the total data dictionary name in the denominator.