How do I work with sum/max/min/count/average?

To use mathematical operations in the query builder with Select queries you will need to manually write your query in the editor with the sum/max/min/count and average commands.

Example: SELECT MIN(Employees.Salary) as minsalary , MAX(Employees.Salary) as maxsalary FROM Employees

To see the result, you will need to enter %minsalary% and %maxsalary% in to the Response Message Format Screen.

Notes:

1. In terms of security, there are no view permissions on these newly created fields.

2. The assigned name is case sensitive and should be exactly the same in the query builder as in the response message format screen

3. The assigned name must be different from any real field names in the dataview.