> 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.

![](/files/hOv9ZjRtUXRgUFANJz2I)
{% 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.

![](/files/JjqJp5gq4FHUsucp8LMw)
{% endtab %}
{% endtabs %}

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

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