Task 4. Create a Rule
In this task, you create a rule that sums up the current balances from the checking and savings accounts that have increased by 15 percent.
1. On the Column Mapping tab, click Actions > Edit > Rules.
The Edit Mapping Specification window appears.
2. Select the New Rule icon.
The New Rule window appears.
3. Select Create a rule.
4. Click Next.
5. Enter CurrentBalance as the rule name.
6. On the Target Column Name, select the CURRENT_BALANCE target column.
7. Enter the following expression in the Expression Editor:
(CUSTOMERS.CHECKING_BALANCE+CUSTOMERS.SAVINGS_BALANCE)*1.15
8. Click the Validate icon to validate the expression.
The Analyst tool displays a message that states the expression is valid.
9. Click OK.
10. Click Finish.
11. Click Save.