topic Inventory turns calculation in QlikView https://community.qlik.com/t5/QlikView/Inventory-turns-calculation/m-p/815281#M1027775 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate inventory turns (cost of goods sold / average inventory) by quarter. I have included a sample data set. Please see attached.</P></BODY></HTML> Mon, 16 Feb 2015 14:44:32 GMT hobanwashburne 2015-02-16T14:44:32Z Inventory turns calculation https://community.qlik.com/t5/QlikView/Inventory-turns-calculation/m-p/815281#M1027775 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate inventory turns (cost of goods sold / average inventory) by quarter. I have included a sample data set. Please see attached.</P></BODY></HTML> Mon, 16 Feb 2015 14:44:32 GMT https://community.qlik.com/t5/QlikView/Inventory-turns-calculation/m-p/815281#M1027775 hobanwashburne 2015-02-16T14:44:32Z Re: Inventory turns calculation https://community.qlik.com/t5/QlikView/Inventory-turns-calculation/m-p/815282#M1027776 <HTML><HEAD></HEAD><BODY><P>Hi Scott, you can use an expression like:</P><P>Sum(COGS)/Avg(Aggr(Sum(Qty_OnHand * UnitCost), CalYearMonth))</P></BODY></HTML> Mon, 16 Feb 2015 14:49:33 GMT https://community.qlik.com/t5/QlikView/Inventory-turns-calculation/m-p/815282#M1027776 rubenmarin 2015-02-16T14:49:33Z