Add an Assignment Rule to a Transaction Table Group

1. Activate the Rules workspace, and select a model.
2. Select File Add Assignment Rule (or click the Add Assignment Rule icon ).
3. Name the rule.
4. Select the transaction table group to which you want to assign the rule.
5. Click Define to specify selection criteria.
6. Specify selection criteria to filter the rows in a transaction table group to include in a calculation.
   
   To specify selection criteria:
   1. Select a column in the transaction table.
   2. Select an operator to apply to the selected column:
      
      

      If the selected column is:	You can use the following operators:
      Text	=, not = match Behavior
      Numeric	=, not =, <, <=, >, >= match Behavior
      Dimension	is child of match Behavior

   3. Select a value to compare the column to.
   4. Click Add New Row to add another condition to the selection criteria.
      
      Note: If you are using the match Behavior operator, then each condition must be joined with the And operator.
   5. Click OK.
7. Select one or more numeric fields to use in the driver formula.

   The driver formula can be any of the following:

   Formula:	Example:
   Single numeric property	AMT
   Multiple numeric properties	(COUNT * .05) + (AMT * .01)
   Single entered value	15
   SAS numeric expression	MAX(Requests, Complaints)*.25 EUROCURR(AMT,'eur','frf') IF CustID ='C00650' THEN (0.54*Distance) ELSE IF CustID ='C00692' THEN (0.74*Distance) ELSE (0.23*Distance)

8. Click OK.
   
   The assignment rule appears in the Rules workspace under the transaction table group to which the rule belongs.