We are using Bunnings Counter Sales Data which is collected weekly. I would like to create a calculation that gives me the average stock on hand per month. Has anyone had success with this?
Hi Lisa, yes, I’ve used this logic to create metrics such as Inventory Turns & Days. The key to doing so is having a historical snapshot of the on hand inventory (in our case we capture on a monthly basis at EOM).
If you have a weekly snapshot of on hand inventory available in your database, you can then simply create a custom calculation with one variable that sums the inventory quantity or value divided by {Period_Count} (which counts the number of periods in the cacluation):
a / {Period_Count}
1 Like