Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Example 3: Entering Multiple Selection Criteria

Example 3: Entering Multiple Selection Criteria

If you specify restrictions in more than one field on the Charge Query Specifications panel, a compound condition results. In order for CA PMA Chargeback to select a record for display, the record must meet all the criteria requirements.

To construct a compound condition using the entries for examples 2a and 2b:

• Set the Summarize and Break fields to Y (see A below)
• Enter CPU-CHARGE in the area next to Charge Element (see B below)
• Enter 001 in the first field for Period Number and 003 in the second field (see C below)
• Set the Brk field for Period Number and Charge Element to Y. This allows CA PMA Chargeback to display results by period and Charge Element (see D below).

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

The next panel shows the results of entering multiple criteria on the Charge Query Specifications panel. Note the following:

• Three groups of records meet the criteria specified (see A below). CA PMA Chargeback displays each group, representing one accounting period for Charge Element CPU-CHARGE, separately.
• The Record Count, Units, and Charge fields show totals for those records that fall in Period 1 where Charge Element = CPU-CHARGE (see B, C, and E below).
• The Rate field shows the average rate of the resulting records that fall in Period 1 where Charge Element = CPU-CHARGE (see D below).

 +-- CBQQRYB ----------------- Charge Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | ---------------------------------------------------------------------A.---- |
 |                                          More: + - 1     Row: 0001 of 0003  |
 |  Table  . . . . . : TAB                                                     |
 |  Version  . . . . : PROD PROD         Record Count :                2   B.  |
 |  ORD Type . . . . :                   Units  . . . :          2.00000   C.  |
 |  Charge Element . : CPU-CHARGE        Rate . . . . :           .50000 AVG   D.
 |  Qualifier  . . . :                   Charge . . . :          1.00000   E.  |
 |  Period Number  . : 1                 Debit Amt  . :                        |
 |  DIVISION . . . . :                   Credit Amt . :                        |
 |  DEPARTMENT . . . :                   Adjust Charge:                        |
 |                                       Budget . . . :                        |
 |                                       % of Budget  :                        |
 +-----------------------------------------------------------------------------+