Selecting from a Range of Values
To select customers with sales in the $25,000.00 to $30,000.00 range, specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME 0002 STATE 0003 CUSTOMER CLASS 0004 AMOUNT OF SALES 25000 THRU 30000 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT
This expression selects all rows with a sales amount between $25,000.00 and $30,000.00
Selecting from a List of Values
To select all customers in New England, specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME 0002 STATE 'MA','ME','VT','CT','RI','NH' 0003 CUSTOMER CLASS 0004 AMOUNT OF SALES 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT
This expression selects all rows with a state column containing the abbreviation of a New England state.
Selecting Based on Equal Values
To select customers named O'Brien that have an AAA class rating, specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME 'O''BRIEN' 0002 STATE 0003 CUSTOMER CLASS 'AAA' 0004 AMOUNT OF SALES 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT
These expressions select all rows with the name O'Brien and a customer class of AAA.
Selecting Based on Relative Values
To select customers who consistently make late payments, specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME 0002 STATE 0003 CUSTOMER CLASS 0004 AMOUNT OF SALES 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT GE #5 + #6
This expression selects all rows in which the LATE PAYMENT COUNT is greater than or equal to the EARLY PAYMENT COUNT (referenced by its column ID number 5) plus the ONTIME PAYMENT COUNT (referenced by its column ID number 6).
Selecting Based on a Contained Value
To select all customers who have one of the class A ratings, specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME 0002 STATE 0003 CUSTOMER CLASS CONTAINS 'A' 0004 AMOUNT OF SALES 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT
This expression selects the following customer classes: A, AA, AB, AAA, and BAA.
Selecting Based on Matching Values
To select all customers whose names begin with O' (such as O'Brien), specify selection criteria as follows:
ID Column Name Selection Criteria 0001 CUSTOMER NAME MATCHES 'O''@' 0002 STATE 0003 CUSTOMER CLASS 0004 AMOUNT OF SALES 0005 EARLY PAYMENT COUNT 0006 ONTIME PAYMENT COUNT 0007 LATE PAYMENT COUNT
This expression selects only rows that contain a customer name beginning with O'. The mask character @ (representing any alphabetic character) is used to delimit the doubled quotation marks.
Using Freeform Selection Criteria Alone
To select rows based on an OR condition, specify additional selection criteria as follows:
ID Column Name Selection Criteria
0001 CUSTOMER NUMBER
0002 NUMBER OF SALES
0003 AMOUNT OF SALES
Additional Selection Criteria
COL(NUMBER OF SALES) GT 500 OR COL(AMOUNT OF SALES) GT 5000
This expression selects all rows with either more than 500 sales or more than $5,000 in sales. The criteria can also be specified using the column ID numbers rather than the column names, as follows:
Additional Selection Criteria
#2 GT 500 OR #3 GT 5000
Using Freeform Selection Criteria with Fixed-Format Expressions
The selection condition in the above example can also be specified as follows:
ID Column Name Selection Criteria
0001 CUSTOMER NUMBER
0002 NUMBER OF SALES GT 500
0003 AMOUNT OF SALES GT 5000
Additional Selection Criteria
$2 OR $3
Note that the OR in the freeform expression overrides the implied AND in the fixed-format expressions.
|
Copyright © 2014 CA.
All rights reserved.
|
|