Report Totals

Reports can include column totals in the form of sums, averages, or counts. The Totals filter option is located in the Report Filter window Settings List.

Use the following table to help you set your report Totals filter.

Report Heading	Description
Column	Contains the heading names for the report columns. Note: If you select a column for totals, make sure it is also selected on the Columns filer so it displays on the report.
Sum/ Average/ Count	Determines the totals you want to include in your report. A indicates the information selected. You can select only one option for each column name. Sum: Total of all the numbers in the column added together. Average: Average of the column (the sum divided by the number of records in the column). Count: Total number of records in the column. Note: When n/a displays for an item, you cannot select the indicated total option. For example, n/a would display for dates because you cannot sum or average dates.
Total	Adds the sums from all columns to determine the total. This value displays as the dollar amount in parentheses next to the "Group By" totals. If no columns have "Totals" checked, then no amount displays in the parenthesis.
Report Total Caption	Free text that displays next to the Grand Total in the report.
SubTotal Prefix	Free text that displays next to the subtotals in the report.
Total Lines Only	Checking this box displays total lines only instead of detailed information.
Count Records	A count of the number of all record rows in the report. The counts display at the end of each grouping as a subtotal and at the end of the report for the total number of records in the entire report. If there is a "Group By" total, then the count displays as a non-dollar amount in the parentheses next to the total. If this is left unchecked, then no amount displays in the parentheses.