Applying Aggregate Functions in Composite Queries

To apply aggregate functions to the output field of composite queries:

  1. Select Reporting Tools, Composite Query, Composite Query Manager.

  2. Open an existing composite query or create a new one.

  3. In the Composite Query Manager page - Fields section, select an aggregate option from the Aggregate drop-down list.

    The available options are Average, Count, Count Distinct, Max, Min, and Sum.

    Image: Composite Query Manager page - Fields section - Aggregate functions

    This example illustrates the fields and controls on the Composite Query Manager page - Fields section. The aggregate value for the EMPLOYEE.“A.EMPLID” is set to Count.

    Composite Query Manager page - Aggregate functions

  4. Optionally, click the SQL button to verify the aggregate setting on the generated SQL.