Group by shows you that you are including all of the rows in the report in your computation. Specify that you want to know the sum of all the employee salaries in the report. Use Seq to specify the column under which you want the computed field displayed.
CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 1 136000 Specify summary computations and press the ENTER key Group by: ALL Level# Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME 4 _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 3 x _ _ _ X PROJECT 2 _ _ _ _ COMPUTE FIELDS: X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E 3 MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID 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 calculate the report total.
CA OLQ Release nn.n *** Report Format - Sort *** -> Page 1 of 1 133000 Specify sort or group by request and press the ENTER key Disp Sort Order Group By Seq Priority (A/D) Level # EMPLOYEE X EMP-LAST-NAME 4 _ _ _ X DEPT-ID 1 1 A 1 X SALARY-AMOUNT 3 3 A _ X PROJECT 2 2 A _ 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 Display lines: Detail X and/or Summary X Group by all X Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 11=HEADER
|
Copyright © 2013 CA.
All rights reserved.
|
|