Building the Action Diagram › How to Define Logic for Elementary Processes and Procedures › Add Assignment Actions › Add SUMMARIZE EACH Entity Action › Subgroup Aggregation With Entity Qualifiers

Subgroup Aggregation With Entity Qualifiers

Use the following statement to determine the total salary of exempt and non-exempt employees in department 3:

SUMMARIZE EACH GROUP OF employee 
WITH THE SAME employee classification 
PLACING employee classification 
INTO local employee classification 
PLACING GROUP sum(employee salary) 
INTO local employee salary 
WHERE DESIRED employee belongs to SOME department 
AND THAT department id = 3