Forum Discussion
Monthly Inventory Value
Hi, I have data with weekly inventory values per product and store. What I need to get to is the below 2 measures: 1. Average Total Inventory by Product per Month 2. Last/Latest Total Inventory...
Thanks Ashish. The Last Total Inventory calculation is working well but the Average Total Inventory is not working with my actual data, I'm getting very low figures which don't add up.
You are welcome. I cannot say why my formulas are not working with your data. From the file that i have shared with you, my calculations work fine and tally with the your expected result. How can i help you further?