https://community.qlik.com/t5/QlikView/weighted-average/m-p/2009250#M1221669 <P>Hi, I have a table like this:</P> <P>&nbsp;</P> <P>Order_Id&nbsp; &nbsp; &nbsp; &nbsp;Price&nbsp; &nbsp; &nbsp;Quantity</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P> <P>&nbsp;</P> <P>How can I calculate the&nbsp;weighted average of the price based on the quantity?</P> <P>&nbsp;</P> Fri, 25 Nov 2022 14:25:39 GMT ValeriaBonini 2022-11-25T14:25:39Z https://community.qlik.com/t5/QlikView/weighted-average/m-p/2009250#M1221669 <P>Hi, I have a table like this:</P> <P>&nbsp;</P> <P>Order_Id&nbsp; &nbsp; &nbsp; &nbsp;Price&nbsp; &nbsp; &nbsp;Quantity</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34</P> <P>&nbsp;</P> <P>How can I calculate the&nbsp;weighted average of the price based on the quantity?</P> <P>&nbsp;</P> Fri, 25 Nov 2022 14:25:39 GMT https://community.qlik.com/t5/QlikView/weighted-average/m-p/2009250#M1221669 ValeriaBonini 2022-11-25T14:25:39Z https://community.qlik.com/t5/QlikView/weighted-average/m-p/2009255#M1221670 <P>Hi,</P> <P>If it's in chart:</P> <P>Sum(<SPAN>Price&nbsp;</SPAN>*<SPAN>Quantity</SPAN>) / Sum(<SPAN>Quantity</SPAN>)</P> Fri, 25 Nov 2022 14:42:44 GMT https://community.qlik.com/t5/QlikView/weighted-average/m-p/2009255#M1221670 Aurelien_Martinez 2022-11-25T14:42:44Z