Defining item counting and totaling functions

The manner in which a Human Resource Writer report counts or totals data depends on how you complete the Print Total field on Human Resource Writer Format Item Order (HR65.3) and the Total field on Human Resource Writer Print Order (HR65.4).

To define item counting and totaling functions

To count the number of employees or applicants included in a report, the Employee or Applicant must be included as data items in the report. Select C in the Print Total field on HR65.3 for the Employee or Applicant data item. In the Total field on HR65.4, select Y for each sort level for which you want to see counts (the report will also show a count for the entire report); select R for each sort level to get just a count of records with no detail.
To total a numeric value column in the report, select Y in the Print Total field on HR65.3 for the numeric data item. In the Total field on HR65.4 for sort level(s), you have the following options:
- Select Y for column totals
- Select A for averages
- Select R for count of the number of records associated with a data item with detail suppressed
- Select S for column totals with detail suppressed
- Select Z for averages with detail suppressed
To summarize historical records, select R in the Print Total field on HR65.3 for all data items beside the one to be summarized. Select Y in the Total field on HR65.4.

Example

In the following example, the Payroll Author has created a Deduction History report. Because the detail topic PD (Payment Detail) was selected, each payment in history will be examined for the specified information. Rather than see each deduction amount in history for a date range, amounts can be summarized.

To summarize amounts, an "R" is entered for all data items except for "Deduction Amount" data item which will have a "Y." The "R" will retain the data items to print when the detail is summarized. The "Y" will allow totals at the define sort/total levels established in Human Resource Writer Print Order (HR65.4).