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 columns 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 added rule displays in the Rules workspace under the transaction table group to which the rule belongs.