In this step, you sort your report rows by salary grade, and compute the average salary in each salary grade. Start on the Report Format - Sort screen. To get there, type sort in the command line.
Sort your rows in ascending order by salary grade; group your report rows by salary grade. Sort within salary grade by salary amount.
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-0415 1 _ _ _ X SS-NUMBER-0415 2 _ _ _ EMPOSITION X SALARY-GRADE-0420 3 1 a 1 X SALARY-AMOUNT-0420 4 2 a _ Display lines: Detail X and/or Summary X Group by all _ Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 11=HEADER
For each salary grade group, calculate the average salary amount.
CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 1 136000 Specify summary computations and press the ENTER key Group by: SALARY-GRADE-0420 Level# 1 Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME-0415 1 _ _ _ _ X SS-NUMBER-0415 2 _ _ _ _ EMPOSITION X SALARY-GRADE-0420 3 _ _ _ _ X SALARY-AMOUNT-0420 4 _ x _ _ Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 10=PICTURE
CA OLQ displays the average salary for each salary grade group.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE/EMPOSITION REPORT mm/dd/yy SOCIAL SECURITY SALARY NAME NUMBER GRADE SALARY ─────────────── ─────────── ────── ────────────────────── FITZHUGH 11-234-5678 11 13000.00 TERNER 04-567-2222 11 13000.00 JOHNSON 01-134-7878 11 13500.00 ─────────── AVE FOR 11: 13166.66 NICEMAN 03-345-6110 12 14000.00 GARDNER 02-233-4444 12 14000.00 KRAAMER 02-378-6666 12 14000.00 KING 06-784-5516 12 14500.00 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
|
Copyright © 2013 CA.
All rights reserved.
|
|