> For the complete documentation index, see [llms.txt](https://resources.less.tech/less-tech/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.less.tech/less-tech/modelling/action-guides/basics/filter.md). # Filter

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. {% embed url="" %} The Filter Action {% endembed %} ## 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.