Single-Field Functions

Perform single-field functions (SQL aggregate functions) in Summary reports. Calculations are specified in the Add Columns of Calculations section of the report form.

Perform the following functions:

• AVG (Average) – Average all values in a field.

• MAX (Maximum) – Return the maximum value in a field.

• MIN (Minimum) – Return the minimum values in a field.

• SUM (Sum) – Return the sum of all values in a field.

For example, to determine the last time an item was submitted into a particular project, specify the following parameters in the Calculated Fields to Display section of the report form: Last Item Submitted = MAX of Submit Date/Time. When you run the report, the date and time the last item was submitted into the queried project appears in the Last Item Submitted column.

Microsoft SQL Server users might experience difficulties performing averages on date fields. To avoid errors, only perform date averages on a small number of records.