Calculate a total or average value in a report

You can calculate the total or average value for numeric or currency columns in a Listing report. For example, you could calculate the total insurance value of a group of records.

Steps

1. On the Edit Report Template tab of the Reporting tool, under Field Orientation, make sure the Field (Across the page) option is selected.
2. Click Select Fields and add fields to the list of Display Fields.
3. Click a display field and click the  Detail button.
4. Under Statistic, select Total or Average.
   
5. Click OK to close the Column Description window.
6. Click OK to close the Display Fields window.

Note: You can’t add a Total and an Average to the same field.