Setting Numeric Totals

The Report Field Options window, accessible from the Report Setup window, allows you to specify whether or not numeric fields should be totaled at specified groupings and at the end of the report.

Whether or not totals are displayed for numeric fields is based on settings made on the General > Sort/Group sub-tab and in the Report Field Options window. Numeric fields are typically set to total at the end of a report and at any defined groupings for which totals have been specified.

Modify the total setting for a numeric field:

1. Select the field you want to modify from the Display field.

2. Click the Edit button.

   The Report Field Options window for the selected field opens.

3. Choose between two options:

   • Select the Yes option button for the Total if Selected setting to include a total at the end of the report and at any defined groupings which are set to total.

   • Select the No option button for the Total if Selected setting to remove any total calculations.

     Selecting No ensures that there are no totals displayed for this field at any defined groupings or at the end of the report. This setting takes precedence over the setting on the General > Sort/Group sub-tab, which applies more generally to all fields on the report.

4. Click the Apply button.

   You are returned to the Report Setup window.

5. Click the Apply button.

   The Report Preview window displays. If you accessed the Report Setup window from the Report List, you are returned to the Report List.