Group by displays EMPLOYEE.PROJECT as the current group level. Level# displays 2 as the current group level. Specify that you want to count the number of employees within each project.
CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 1 136000 Specify summary computations and press the ENTER key Group by: EMPLOYEE.PROJECT Level# 2 Seq Sum Avg Max Min Count x EMPLOYEE X EMP-LAST-NAME 4 _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 3 _ _ _ _ X PROJECT 2 _ _ _ _ COMPUTE FIELDS: X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM OUNT) GROUP BY ALL LEVEL 1 Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 10=PICTURE
CA OLQ generates this COMPUTE statement to count the total number of employees working on each project.
CA OLQ Release nn.n *** Report Format - Group By *** -> Page 2 OF 2 136000 Specify summary computations and press the ENTER key Group by: EMPLOYEE.PROJECT Level# 2 Seq Sum Avg Max Min Count X COMPUTE FIELDS: X 'EMPLOYEE.PROJECT-COUNT-2'=COUNT GROUP BY EMPLOYEE.PROJECT LEVEL 2 Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 7=BWD 10=PICTURE
|
Copyright © 2013 CA.
All rights reserved.
|
|