Aggregates in Query Manager
Users can count employees, sum payroll dollars, find most recent paycheck date, and calculate other
aggregate values in Query Manager. Aggregates in Query Manager are similar to pivot tables in
Microsoft Excel: they allow users to quickly summarize data.
The available aggregate functions are Sum, Count, Minimum, Maximum, Average, and Count Distinct.
Query results can be restricted by aggregate values using the Having tab. Aggregates can also be used in
Expressions.
Procedure for Aggregating a Field
Create your query with desired Records, Fields, and Criteria. The field you want to use as an
aggregate has to be a field in your query. For example, if you want to count employees, the
EMPLID field needs to be included in the query.
Find the field that you want to summarize and click the Edit button on that row.
On the Edit Field Properties page, in the Aggregate box, select the aggregate function you want
to use. The available options are Sum, Count, Min, Max, Average, and Count Distinct.