https://community.qlik.com/t5/App-Development/Average-Cost-per-Unit/m-p/1809998#M65999 <P>Good day</P><P>I'm trying to calculate: Stock On Hand per item&nbsp; * Average cost per unit.</P><P>I Have the following:</P><P>avg(aggr(sum([AverageCost]),(STOCK_ON_HAND)))&nbsp;</P><P>It's not giving right value. Is there anyway of getting an average either by using aggr function or a different way?</P><P>&nbsp;</P> Mon, 24 May 2021 08:24:49 GMT Khanyie_ 2021-05-24T08:24:49Z https://community.qlik.com/t5/App-Development/Average-Cost-per-Unit/m-p/1809998#M65999 <P>Good day</P><P>I'm trying to calculate: Stock On Hand per item&nbsp; * Average cost per unit.</P><P>I Have the following:</P><P>avg(aggr(sum([AverageCost]),(STOCK_ON_HAND)))&nbsp;</P><P>It's not giving right value. Is there anyway of getting an average either by using aggr function or a different way?</P><P>&nbsp;</P> Mon, 24 May 2021 08:24:49 GMT https://community.qlik.com/t5/App-Development/Average-Cost-per-Unit/m-p/1809998#M65999 Khanyie_ 2021-05-24T08:24:49Z