Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day
I'm trying to calculate: Stock On Hand per item * Average cost per unit.
I Have the following:
avg(aggr(sum([AverageCost]),(STOCK_ON_HAND)))
It's not giving right value. Is there anyway of getting an average either by using aggr function or a different way?