4.2.3.3.2.4 Expressions Filter

Expressions filters help to include calculated conditions in filters.

To create an Expression filter, proceed with the following steps, after selecting the Database table name, column name and the Data element.

Refer to the following steps, to create a Expressions filter:

1. Select Expressions in the Filter Methods.
2. Refer to the following steps, to include an expression and filter the data based on the calculated output.
   1. Select one of the Operator (> or >=), to process the data in the specific column.
      • = - Equal to
      • <> - Not equal to
      • < - Lesser than
      • > - Greater than
      • <= - Lesser than or equal to
      • >= - Greater than or equal to
   2. Select the Expression for comparing the data in the selected table column.
3. Click Add to add the expression to the filter condition.
   To edit an existing Expression Filter entry, select the entry listed in the Filter Condition pane. Modify the expression in the Expressions pane and click Update.
4. To delete a range, select the range by clicking the check-box adjacent to the value. Click Delete.
5. To view the SQL statement for the specific range, select the range and click View SQL.