topic Re: Weighted Average calculation in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average-calculation/m-p/1038587#M465370 <HTML><HEAD></HEAD><BODY><P>These may be:</P><P></P><P>1) <STRONG>=Sum(Price)/Count(DISTINCT Month)</STRONG></P><P>2) <STRONG>=Avg(Price)</STRONG></P><P>3) <STRONG>=Sum(Price*Quantity)/Sum(Quantity)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118837_Capture.PNG" style="height: 178px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 21 Mar 2016 16:50:44 GMT sunny_talwar 2016-03-21T16:50:44Z Weighted Average calculation https://community.qlik.com/t5/QlikView/Weighted-Average-calculation/m-p/1038586#M465369 <HTML><HEAD></HEAD><BODY><P>I would like to create a column in a pivot table that shows the weighted average unit price.&nbsp; What would be the formula for this?</P><P></P><P>Here is the data:</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE><TBODY><TR><TD></TD><TD>Price</TD><TD>Quantity</TD></TR><TR><TD>Jan</TD><TD> -&nbsp; </TD><TD> -&nbsp;&nbsp; </TD></TR><TR><TD>Feb</TD><TD> 1.59</TD><TD> 15,903.00 </TD></TR><TR><TD>Mar</TD><TD> 1.65</TD><TD> 28,187.00 </TD></TR><TR><TD>Apr</TD><TD> 1.55</TD><TD> 28,330.00 </TD></TR><TR><TD>May</TD><TD> 1.45</TD><TD> 27,755.00 </TD></TR><TR><TD>Jun</TD><TD> 1.39</TD><TD> 28,987.00 </TD></TR><TR><TD>Jul</TD><TD> 1.44</TD><TD> 14,002.00 </TD></TR><TR><TD>Aug</TD><TD> 1.23</TD><TD> 44,112.00 </TD></TR><TR><TD>Sep</TD><TD> 1.40</TD><TD> 28,181.00 </TD></TR><TR><TD>Oct</TD><TD> -&nbsp; </TD><TD> -&nbsp;&nbsp; </TD></TR><TR><TD>Nov</TD><TD> -&nbsp; </TD><TD> -&nbsp;&nbsp; </TD></TR><TR><TD>Dec</TD><TD> 1.65</TD><TD> 100,000.00 </TD></TR></TBODY></TABLE><P></P><TABLE><TBODY><TR><TD>Avg Price</TD><TD> 1.1133 </TD></TR><TR><TD>Avg non Zero</TD><TD> 1.4844 </TD></TR><TR><TD>Wtd Average</TD><TD> 1.5079 </TD></TR></TBODY></TABLE><P></P><P>What is the formula the weighted average?</P></BODY></HTML> Mon, 21 Mar 2016 16:43:20 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-calculation/m-p/1038586#M465369 Anonymous 2016-03-21T16:43:20Z Re: Weighted Average calculation https://community.qlik.com/t5/QlikView/Weighted-Average-calculation/m-p/1038587#M465370 <HTML><HEAD></HEAD><BODY><P>These may be:</P><P></P><P>1) <STRONG>=Sum(Price)/Count(DISTINCT Month)</STRONG></P><P>2) <STRONG>=Avg(Price)</STRONG></P><P>3) <STRONG>=Sum(Price*Quantity)/Sum(Quantity)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/118837_Capture.PNG" style="height: 178px; width: 620px;" /><BR /></STRONG></P></BODY></HTML> Mon, 21 Mar 2016 16:50:44 GMT https://community.qlik.com/t5/QlikView/Weighted-Average-calculation/m-p/1038587#M465370 sunny_talwar 2016-03-21T16:50:44Z