Begin by navigating to the Fields page.
Click the Reporting Tools link.Step 1
Click the Query Manager link.Step 2
Click the Search button.Step 3
Click an entry in the Edit column.Step 4
Use the Fields page to:
• View how fields are selected for output.
• View the properties of each field.
• Change headings, order-by numbers, and aggregate values.Step 5
Click the Edit button.Step 6
Use the Edit Field Properties page to format the query output, including aggregate functions.Step 7
If you are using aggregate values, select the aggregate function value for the field being edited.Step 8
The available aggregate functions in Query Manager are:
• AvgStep 9
Select the Sum option to add the values from each row and display the total.Step 10
Select the Count option to count the number of rows.Step 11
Select the Min (minimum) option to check the value from each row and return the lowest one.Step 12
Select the Max (maximum) option to check the value from each row and return the highest one.Step 13
Select the Average option to add the values from each row and divides the result by the number of rows.Step 14
You have successfully reviewed the Using Aggregate Functions topic.
Table of Contents Start Topic