Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Scott, you can use an expression like:
Sum(COGS)/Avg(Aggr(Sum(Qty_OnHand * UnitCost), CalYearMonth))
Hi Scott, you can use an expression like:
Sum(COGS)/Avg(Aggr(Sum(Qty_OnHand * UnitCost), CalYearMonth))