As per my understanding of the above mentioned problem statement, I have tried to build the desired result.
You can check the attached packaged workbook, I hope it will be helpful for you.
Tableau Forums File.twbx 21.7 KB
Thanks for the help!
The Inventory calculation is absolutely perfect! and thanks for that!
In the WOC calculation it's my fault that i wasn't clear enough because the inventory was the priority.
Umm i guess what you have done is divide the inventory for that date with the total demand for that day.
I am trying to create something more on the lines of calculating WOC based on the future demand forecast.
MrExcel Message Board This link is similar to what i'm using right now in my excel files
MrExcel Message Board For that I am using a version of the formula shown here.
I'd be grateful if you had any ideas about his.