# Exclude delivery not required in results

**URL:** <https://community.breww.com/t/exclude-delivery-not-required-in-results/2544>\
**Category:** Help & advice\
**Tags:** orders\
**Created:** [17 May 2023 07:19 UTC](https://community.breww.com/t/exclude-delivery-not-required-in-results/2544 "2023-05-17T07:19:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\
**Post date:** [17 May 2023 07:19 UTC](https://community.breww.com/t/exclude-delivery-not-required-in-results/2544/1 "2023-05-17T07:19:38Z")

</div>

HI,

I would like to filter sales on “deliverycollection = None” but exclude “delivery not required” results as it clutters the results.

Is there a formula for that\>

---

<div class="post-metadata">

**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\
**Post date:** [17 May 2023 08:28 UTC](https://community.breww.com/t/exclude-delivery-not-required-in-results/2544/2 "2023-05-17T08:28:09Z")

</div>

Hi Gijs,

`deliverycollection = None and fulfillment_required = True`

The above should do the trick! You’ll need to be on a ‘sales/invoices’ report for the above to work directly. If you’re on a ‘products sold’ report, you’d need to add `invoice.` before each filter.
