Add an Assignment Rule to a Transaction Table Group
-
Activate the Rules workspace, and select a model.
- Select File Add Assignment Rule (or click the Add Assignment Rule icon ).
- Name the rule.
- Select the transaction table group to which you want to assign the rule.
- Click Define to specify selection criteria.
- 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:
- Select one or more columns in the transaction table group.
- 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
- Select a value to compare the columns to.
- 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.
- Click OK.
- After building the selection criteria, modify the conditions manually, as necessary.
- Select a numeric column to use in the driver formula.
Note: You are not restricted to a single field.
- Click OK.
The added rule displays in the Rules workspace under the transaction table group to which the rule belongs.