# How to Exclude No value

**URL:** <https://community.hubspot.com/t/how-to-exclude-no-value/132515>\
**Category:** Reporting & Analytics\
**Tags:** enterprise\
**Created:** [May 12, 2025, 9:44am UTC](https://community.hubspot.com/t/how-to-exclude-no-value/132515 "2025-05-12T09:44:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBattuello](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@SBattuello](https://community.hubspot.com/u/SBattuello)\
**Post date:** [May 12, 2025, 9:44am UTC](https://community.hubspot.com/t/how-to-exclude-no-value/132515/1 "2025-05-12T09:44:14Z")

</div>

Hello,

I am building a report from a form.

I have a issue with a question of the report..

I would like to exclude the ‘no value’ but even if I set the filter ‘is known’ or is any of ‘…’ it continues to show me the ‘no value’;

do you have nay suggestions??

 ![Screenshot 2025-05-12 114305.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/c/e/ce26ce2966ffdc7dec9fcc39121f7911b63166d7.png)

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [May 12, 2025, 9:46am UTC](https://community.hubspot.com/t/how-to-exclude-no-value/132515/2 "2025-05-12T09:46:03Z")

</div>

Hi @SBattuello,

That’s probably because you combined the filters via OR (meaning only one of the two must be true for a contact to “enter” the report). You would have to make it an AND.

Best regards
