Filter

Make rules that removes rows

The Filter Action

The Filter Action reduces the amounts of rows in your data set by making rules that remove records. Maybe you only want expense rows with an amount larger than 500. See the video below for an example of how to use the Filter Action.

The Filter Action

About AND and OR Clauses

The clauses are used to group (AND) or (OR) separate multiple conditions in the Filter Action. The Filter Action evaluates whether the conditions are true/fulfilled and outputs the rows where the conditions are true/fulfilled. You use the AND and OR clauses in the following ways:

• The AND operator groups conditions together meaning both of these have to be true to output a given row. If you, for instance, want to look at expenses that are larger than 500 with an expense type equal to "software costs", you would use the AND operator.

• The OR operator displays a row if any of the conditions are true. If you, for instance, want to look at expenses that are larger than 500 or smaller than 50, you would use the OR operator.

Nulls

You can filter for null values with the syntax below. Simply type in Null in the value field and you be able to include/exclude null values.