Forum Discussion
Solved
Inventory Count from Count in a Date Range
I have two tables, Date and Inventory. Inventory is a distinct look at inventory with a New date and Sold Date attached. Is there a way to take the Date from the Date Table and count how many times it shows up in the New and Sold ranges. This will give me how much was in inventory on those days.
Inventory Table
| ID | New | Sold |
| 47883602 | 6.23.2022 | 7.01.2022 |
| 41622522 | 7.01.2022 | 7.01.2022 |
| 45181882 | 5.20.2022 | 7.02.2022 |
| 48105302 | 7.01.2022 | 7.03.2022 |
| 43855572 | 6.08.2022 | 7.05.2022 |
| 50316242 | 6.30.2022 | 7.05.2022 |
| 50301082 | 7.01.2022 | 7.05.2022 |
| 50396872 | 7.01.2022 | 7.05.2022 |
| 50137862 | 7.05.2022 | 7.05.2022 |
| 41236432 | 5.16.2022 | 7.06.2022 |
If I look at date 6/08 it would show 3 in inventory, 7/01/2022 would show 9 in inventory
4 Replies
Thank you, this solved a weeks worth of headaches
You are welcome.
You can try just use a simple matrix with [New] as a row, and then the count of [New] as the value. And then do the same for Sold.
