Creating a math rule condition

You can create a math rule to find out all the supplier invoices that has 'Cash' in the payment term description and the total amount is greater than 100000.

Click Design > Business Controls > Rule Books.
Click the arrow option corresponding the Process Insight rule book in which you want to create the new Process Insight rule.
Click New. The New Rule page page is displayed.
Click the Conditions tab.

Select a template to create the conditions. You can create one of these conditions:

Math function - Where Clause
Specify this condition:
```
Condition 1
         Value Set 1
           Sum of
            Supplier Invoice Header~Extended Report Amount
              Where Supplier Invoice Header~Payment Term Description
              contains
              Cash
            Greater Than
          Value Set 2
            100000
```
Note: The rule with this condition will fetch all the supplier invoices that has 'Cash' in payment term description and the total Extended Report Amount is greater than 100000.

Math function - Where clause Group by

Specify this condition:

Group 1
            Condition 1
            Value set 1
              Sum of
               Supplier Invoice Header~Extended Amount
              Where
              Condition 1
               Supplier Invoice Header~Status
               Does not contain
               deleted
              Group by
               Supplier Invoice Header~Invoice ID
               Greater than
            Value set 2
                    100000

Note: You must right click the Conditions, Select Operator, and the Sum of menus to add values.

Click Save.