# Need Boolean NOT or other workaround

**URL:** <https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538>\
**Category:** Dashboards & Reporting\
**Created:** [September 21, 2022, 12:04pm UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538 "2022-09-21T12:04:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ABlindenbache2](https://avatars.discourse-cdn.com/v4/letter/a/8edcca/32.png) [@ABlindenbache2](https://community.hubspot.com/u/ABlindenbache2)\
**Post date:** [September 21, 2022, 12:04pm UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538/1 "2022-09-21T12:04:26Z")

</div>

Hi, I am trying to create a report which of all resellers that HAVE NOT created a deal this year for a certain product ID. I would really need a NOT statement besides AND and OR. Or if any of you have another workaround to this, i am keen to hear it.

---

<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:** [September 21, 2022, 12:05pm UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538/2 "2022-09-21T12:05:39Z")

</div>

Hi @ABlindenbache,

Are resellers created as contact records? If so, you can create a contact list of all contacts which are resellers and then exclude this list from your report via list membership: “Contact is not a member of [reseller list]”.

This is assuming that you created a report with two data sources, contacts and deals. (And yes, agree, a native statement would be great.)

Best regards!

PS. No need to submit a post multiple times 🙂

---

<div class="post-metadata">

**Author:** ![ABlindenbache](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@ABlindenbache](https://community.hubspot.com/u/ABlindenbache)\
**Post date:** [September 23, 2022, 8:26am UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538/3 "2022-09-23T08:26:24Z")

</div>

Thanks Karsten for the workaround idea. I’ll have a look if that is an option for us.

Posted more than once to give importance, since I saw in the forum that this is a common problem that has not been addressed.

---

<div class="post-metadata">

**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\
**Post date:** [September 21, 2022, 12:28pm UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538/4 "2022-09-21T12:28:27Z")

</div>

In addition to the workaround from @karstenkoehler, I’d suggest adding this to the [ideas forum here](https://community.hubspot.com/t5/HubSpot-Ideas/idb-p/HubSpot_Ideas). Or you can upvote + comment on one of these ideas that have been submitted:

- [Add boolean NOT filter to custom report filter](https://community.hubspot.com/t5/HubSpot-Ideas/Add-boolean-NOT-filter-to-custom-report-filter/idi-p/551942)
- [FEATURE REQUEST: Add Boolean Operators to filters (“OR” and “NOT”)](https://community.hubspot.com/t5/HubSpot-Ideas/FEATURE-REQUEST-Add-Boolean-Operators-to-filters-quot-OR-quot/idi-p/363191)

The product teams see these ideas and implement a lot of them.

---

<div class="post-metadata">

**Author:** ![ABlindenbache](https://avatars.discourse-cdn.com/v4/letter/a/da6949/32.png) [@ABlindenbache](https://community.hubspot.com/u/ABlindenbache)\
**Post date:** [September 23, 2022, 8:25am UTC](https://community.hubspot.com/t/need-boolean-not-or-other-workaround/65538/5 "2022-09-23T08:25:10Z")

</div>

Thanks Dan for proposing and posting it to the ideas forum.