https://community.qlik.com/t5/App-Development/Avg-Aggr-issue/m-p/1638628#M47600 <P>Hi -&nbsp;</P><P>I am trying to create a KPI showing the average of the quantity sold / product name based upon the selection.</P><P>=Avg(aggr(sum(QuantitySold), [ProductName]))</P><P>Example - the three values are 483,404,1152.</P><P>The total is 2039 and average is 679.</P><P>It is displaying 2039 instead of 679 - thoughts ?&nbsp;</P> Wed, 23 Oct 2019 01:03:07 GMT jerryr125 2019-10-23T01:03:07Z https://community.qlik.com/t5/App-Development/Avg-Aggr-issue/m-p/1638628#M47600 <P>Hi -&nbsp;</P><P>I am trying to create a KPI showing the average of the quantity sold / product name based upon the selection.</P><P>=Avg(aggr(sum(QuantitySold), [ProductName]))</P><P>Example - the three values are 483,404,1152.</P><P>The total is 2039 and average is 679.</P><P>It is displaying 2039 instead of 679 - thoughts ?&nbsp;</P> Wed, 23 Oct 2019 01:03:07 GMT https://community.qlik.com/t5/App-Development/Avg-Aggr-issue/m-p/1638628#M47600 jerryr125 2019-10-23T01:03:07Z https://community.qlik.com/t5/App-Development/Avg-Aggr-issue/m-p/1638635#M47603 <P>Resolved...</P><P>=Avg(aggr(sum(QuantitySold), [SalesDate.autoCalendar.YearMonth]))</P> Wed, 23 Oct 2019 01:36:50 GMT https://community.qlik.com/t5/App-Development/Avg-Aggr-issue/m-p/1638635#M47603 jerryr125 2019-10-23T01:36:50Z