Calculated Fields

You can have your report calculate numeric fields and these calculations display after the last record in the grid. The available calculations are: 

  • sum
  • average
  • minimum - this lists the lowest value
  • maximum - this lists the highest value

To set up a calculated field, complete the following:

  1. From the Reports Central, click Select Fields and the dialog displays.
  2. Click the Display Settings tab and this displays the numerical fields (decimals or integers) that are found in your report.
  3. For the field you want to calculate, click the Edit icon and the calculate dialog displays.

clipboard_95bcc2de-ebea-446f-b124-cee890de5d7b.png

  1. From Show Totals drop-down, select either: Sum, Average, Minimum, or Maximum. Note that COUNT is not available for the grid, although it is available when working with charts.
  2. Click the Save button.
  3. Click the Done button and the calculation displays at the end of the report's grid.