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.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://resources.less.tech/less-tech/modelling/action-guides/basics/filter.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.