I’ve got a frequent issue in inventory management.
I have only data for specific days (colored cells)
Based on a calendar table, I want a line for each day and for each part number (cartesian product)
Then, I would like to perform the following calculations:
- stock evening* (day) = stock morning (day) - Sales (day) trivial
- stock morning (day +1) = Stock evening (day) row calculation
- A date for each day of the calendar cartesian product
Inventory Calculation.xlsx (14.7 KB)
Do you think it is possible with EM?