Tabular Reports › Use Other Commands with the TAB Command › Create Charge-Back Reports Organized by Group

Create Charge-Back Reports Organized by Group

Use the COST command with the GROUP command to create charge-back reports organized by groups.

Example: COST Command used with GROUP Command

The following commands use terminal IDs to define company divisions and list their corresponding charges in the report:

GROUP TERMID CO.NORTHERN.DIVISION(L4*)
GROUP TERMID CO.SOUTHERN.DIVISION(L3*)
GROUP TERMID CO.EASTERN.DIVISION(L2*)
GROUP TERMID CO.WESTERN.DIVISION(L1*)
COST  TRAN USE  .01
COST  TRAN CPU  .25
TAB TERMID(CO*) HDR1(DEPARTMENT)  HDR2(NAME),
    TRAN USE                                   AND,
    TRAN USE COST                HDR2(COST)    AND,
    TRAN CPU COST HDR1(CPU)      HDR2(COST)    AND,
    REPORT COST TOTAL
END
RUN

A report like the following is generated:

     DEPARTMENT        TRAN     TRAN     CPU     TOTAL
        NAME            USE     COST     COST     COST
-------------------- -------- -------- -------- -------
CO.WESTERN.DIVISION    4415    $44.15   $32.29   $76.44
CO.NORTHERN.DIVISION   2224    $22.24   $15.15   $37.39
CO.EASTERN.DIVISION    2035    $20.35   $15.79   $36.14
CO.SOUTHERN.DIVISION   2024    $20.24   $43.73   $63.97
-------------------- -------- -------- -------- --------
SUMMARY               10698   $106.98  $106.97  $213.94
-------------------- -------- -------- -------- --------