Inventory turns calculation

[hobanwashburne]

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.

[rubenmarin · Accepted solution]

Hi Scott, you can use an expression like:

Sum(COGS)/Avg(Aggr(Sum(Qty_OnHand * UnitCost), CalYearMonth))