![Markus_Wernig Markus_Wernig](https://community.airtable.com/legacyfs/online/avatars/3X/a/1/a1c0636f4eda8d37248990744fd250643c48fe7a.png)
![8 - Airtable Astronomer 8 - Airtable Astronomer](/html/@8B0B6143080A349E4F5B6E12C21C6051/rank_icons/Rank-Astronomer.png)
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
I am trying to solve the following problem:
One table lists all our available products, another table lists projects/jobs in which our products were used and sold for. A rollup on the inventory table counts how many times each product was sold.
But here is the problem - in the project/job table I have an option column that allows me to list a job either as โbidโ or as โactual saleโ. A custom view in that project table allows me to easily view bids and sales, but the rollup in the inventory table counts both options, bids and sales.
Is there a way to tell the rollup to only count sales and ignore bids? That to me sounds like a pretty standard database function, but I cannot figure out how to do it in Airtable.
I am really grateful for any advice.