> For the complete documentation index, see [llms.txt](https://docs.reportpundit.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.reportpundit.com/knowledge-base/report-creation/filters/is-null-and-is-not-null.md).

# 'is Blank' & 'is not Blank'

### How does the 'is Blank' & 'is not Blank' filters work?

{% tabs %}
{% tab title="is Blank" %}
The '**is Blank'** filter condition is used to **filter out** records that have **NULL** values in a particular field. 

***For example***, **filtering** all orders **without an email ID** using the '**is Blank'** filter condition will show **ONLY** those **orders** that **do not have an email ID** recorded in the system.

![](https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2FWQytHGl4jesS7jbduE0E%2Femail-blank.gif?alt=media\&token=a4ef1cad-c1fb-4357-9f36-26ba0a2cbec2)
{% endtab %}

{% tab title="is not Blank" %}
The '**is not Blank'** filter condition will **show** records that **have a value** in the specified field. 

***For example***, applying the 'is not **Blank'** filter condition to the **email ID** field will show **ONLY** those orders that have an **email ID** recorded in the system.

![](https://3511479413-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MVN3iF-DdMhu4BVsTA9%2Fuploads%2Fnd3KQis3JWOE9bBgi6fJ%2Femail-blank-none.gif?alt=media\&token=fd237bc1-a446-4fba-9ad2-62299cbe432f)
{% endtab %}
{% endtabs %}

*Watch this 69 seconds explanatory video to understand better:* 

{% embed url="<https://youtu.be/iViH1LCGMVE>" %}