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.

    You can specify four types of filtering criteria:
    To specify selection criteria:
    1. Select one or more columns in the transaction table group.
    2. Select an operator to apply to the selected columns.
      • Text value operators: =, not =, match Behavior
      • Numeric value operators: =, not =, <, <=, >, >= , match Behavior
      • Dimension value operator: is child of

    3. Select a value to compare the columns 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.
    6. After building the selection criteria, modify the conditions manually, as necessary.

  7. Select a numeric column to use in the driver formula.

    Note: You are not restricted to a single field.
  8. Click OK.



    The added rule displays in the Rules workspace under the transaction table group to which the rule belongs.