Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Example 1: Entering Selection Criteria Within the Charge Element Field

Example 1: Entering Selection Criteria Within the Charge Element Field

To select the records that meet the criterion Charge Element = CPU-CHARGE and display results in a summary report:

• Set the Summarize field to Y (see A below)
• Specify CPU-CHARGE in the area next to Charge Element (see B below)

 +-- CBQQRYS ------------- Charge Query Specifications ------------------------+
 |      Panel   Exit   Help                                                    |
 | --------------------------------------------------------------------------- |
 | Type information for Query CPUCOST   Desc CPU COST FOR PER.1-3    Table TAB |
 |                                                                             |
 | Summarize Y  Break N  Bud/DBCR N           Version : PROD PROD              |
 |            A.                     Brk Srt                            Op Sum |
 | ORD Type . . . .                   N      Rec Count                   > SUM |
 | Charge Element . CPU-CHARGE   B.   N      Units  . .                  > SUM |
 | Qualifier  . . .                   N      Rate . . .                  > AVG |
 | Period Number  .       thru        N      Charge . .                  > SUM |
 | DIVISION . . . .                   N                                        |
 | DEPARTMENT . . .                   N                                        |
 +-----------------------------------------------------------------------------+

The next panel shows the results of entering CPU-CHARGE in the Charge Element field. Note the following:

• CA PMA Chargeback summarizes only those records in the CCCTAB table where Charge Element = CPU-CHARGE.
• The Record Count, Units, and Charge fields show the total amount of record count, units, and charges of those records where Charge Element = CPU-CHARGE (see A, B, and D below).
• The Rate field shows the average rate of the resulting records (see C below).

 +-- CBQQRYZ ----------------- Charge Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | --------------------------------------------------------------------------- |
 |                                          More: + - 1     Row: 0001 of 0001  |
 |  Table  . . . . . : TAB                                                     |
 |  Version  . . . . : PROD PROD         Record Count :              134   A.  |
 |  ORD Type . . . . :                   Units  . . . :         68.16665   B.  |
 |  Charge Element . : CPU-CHARGE        Rate . . . . :        159.05882 AVG  C.
 |  Qualifier  . . . :                   Charge . . . :      14459.99500   D.  |
 |  Period Number  . :                   Debit Amt  . :                        |
 |  DIVISION . . . . :                   Credit Amt . :                        |
 |  DEPARTMENT . . . :                   Adjust Charge:                        |
 |                                       Budget . . . :                        |
 |                                       % of Budget  :                        |
 |                                                                             |
 |   F7=Bkwd   F8=Fwd                                                          |
 +-----------------------------------------------------------------------------+