Forum Discussion
Inventory Availability Coverage
Sorry I linked to the wrong file. The file is here:
https://1drv.ms/u/s!Ancq8HFZYL_aiJBRfsmli39RRmqCOA?e=5Uo1n3
There is an Inventory table and a YesNo table.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi edhans,
Thanks for the reply.
Yes, the results are for ANY warehouse. I tried this, but I found I have another problem. Obviusly, the example was a simplification, but the reality is that the Inventory table is a History Inventory, so the Products are repeated for every month because it is a "picture" of the inventory at the end of each month. I use a Calendar Table to relate dates.
The Inventory Table, in fact, looks like this:
| Product | Warehouse | Quantity | Report Date |
| A | California | 2 | ene-20 |
| A | Miami | 0 | ene-20 |
| B | California | 0 | ene-20 |
| B | Miami | 0 | ene-20 |
| C | California | 0 | ene-20 |
| C | Miami | 1 | ene-20 |
| D | California | 10 | ene-20 |
| D | Miami | 4 | ene-20 |
| A | California | 0 | dic-19 |
| A | Miami | 0 | dic-19 |
| B | California | 1 | dic-19 |
| B | Miami | 0 | dic-19 |
| C | California | 0 | dic-19 |
| C | Miami | 0 | dic-19 |
| D | California | 5 | dic-19 |
| D | Miami | 9 | dic-19 |
And the results I would like to get are these:
| On Hand | ||
| Date | Yes | No |
| ene-20 | 75% | 25% |
| dic-19 | 50% | 50% |
Thanks!
Nicolas.
Well, that would have been very helpful to know up front. My model won't work as the product in the virtual table is no longer unique. I'd have to go back to the drawing board on this one. I'll see if I can play with it tonight.