Using Aggregate Functions


Concept


Steps:

  1. Begin by navigating to the Fields page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. Click the Search button.

    Step 3
  4. Click an entry in the Edit column.

    Step 4
  5. 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
  6. Click the Edit button.

    Step 6
  7. Use the Edit Field Properties page to format the query output, including aggregate functions.

    Step 7
  8. If you are using aggregate values, select the aggregate function value for the field being edited.

    Step 8
  9. The available aggregate functions in Query Manager are:

    •  Sum

    •  Count

    •  Min

    •  Max

    •  Avg

    Step 9
  10. Select the Sum option to add the values from each row and display the total.

    Step 10
  11. Select the Count option to count the number of rows.

    Step 11
  12. Select the Min (minimum) option to check the value from each row and return the lowest one.

    Step 12
  13. Select the Max (maximum) option to check the value from each row and return the highest one.

    Step 13
  14. 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