# Average Inventory - Inventory Turns **URL:** \ **Category:** Ask the Community\ **Tags:** howto\ **Created:** [April 24, 2019, 9:21pm UTC](https://pug.phocassoftware.com/t/average-inventory-inventory-turns/998 "2019-04-24T21:21:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [April 24, 2019, 9:21pm UTC](https://pug.phocassoftware.com/t/average-inventory-inventory-turns/998/1 "2019-04-24T21:21:22Z")
We have a snap shot of our inventory at the end of each month. I need to calculate inventory turns and need to figure out how to get average inventory. I can do this in custom mode, but I may want to change my periods from rolling 12, ytd, etc and can’t make the custom dynamic. ---
**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\ **Post date:** [April 25, 2019, 8:09am UTC](https://pug.phocassoftware.com/t/average-inventory-inventory-turns/998/2 "2019-04-25T08:09:12Z")
How about just setting your offset to pull in the 12 months rolling but in the formula divide by 12? There is a function {Period\_Count} though so you could do the following: ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/0ede3948d63b8760b48cbd58f5a58a3a401fda49.png) ---
**Author:** ![rsavage16](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/rsavage16/32/392_2.png) [@rsavage16](https://pug.phocassoftware.com/u/rsavage16)\ **Post date:** [May 2, 2019, 8:02pm UTC](https://pug.phocassoftware.com/t/average-inventory-inventory-turns/998/3 "2019-05-02T20:02:53Z")
Thank you! I was dividing by 12 but didn’t realize I needed the squiggly brackets.