# Average Stock on Hand

**URL:** <https://pug.phocassoftware.com/t/average-stock-on-hand/2133>\
**Category:** Ask the Community\
**Created:** [March 17, 2022, 4:36am UTC](https://pug.phocassoftware.com/t/average-stock-on-hand/2133 "2022-03-17T04:36:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LisaDowning](https://avatars.discourse-cdn.com/v4/letter/l/7feea3/32.png) [@LisaDowning](https://pug.phocassoftware.com/u/LisaDowning)\
**Post date:** [March 17, 2022, 4:36am UTC](https://pug.phocassoftware.com/t/average-stock-on-hand/2133/1 "2022-03-17T04:36:28Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![dvic](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/dvic/32/1045_2.png) [@dvic](https://pug.phocassoftware.com/u/dvic)\
**Post date:** [March 18, 2022, 3:34pm UTC](https://pug.phocassoftware.com/t/average-stock-on-hand/2133/2 "2022-03-18T15:34:13Z")

</div>

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}

 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/2X/0/0100b65486ca76901a8e15240f41d0ee261aaa26.png)