topic Weighted Average in QlikView https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/387965#M144758 <HTML><HEAD></HEAD><BODY><P>I need to find out the weighted average for one of my columns in KPI, each KPI value need a certain formula to derive the result.</P><P>Is it advisable to list out the formula on the expreesion list?</P><P></P><P>For weighted average,</P><P> below are my data example</P><P></P><P>Type: A Box: 2 Amount : 5</P><P>Type: B Box: 3 Amount 6</P><P>Type: C Box: 5 Amount : 7</P><P>Type: D Box: 6 Amount 8</P><P></P><P>in this above data, the total box will be 2 + 3+5+6 = 16</P><P></P><P>The formula to dervice is</P><P></P><P>(BOX/ TOTAL BOX) * Amount = Result 1</P><P></P><P>Then sum all the result from the above formula to get the weighted average, how do i do it with this complxity. thank you</P></BODY></HTML> Tue, 23 Apr 2013 02:13:40 GMT n1ef5ng1 2013-04-23T02:13:40Z Weighted Average https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/387965#M144758 <HTML><HEAD></HEAD><BODY><P>I need to find out the weighted average for one of my columns in KPI, each KPI value need a certain formula to derive the result.</P><P>Is it advisable to list out the formula on the expreesion list?</P><P></P><P>For weighted average,</P><P> below are my data example</P><P></P><P>Type: A Box: 2 Amount : 5</P><P>Type: B Box: 3 Amount 6</P><P>Type: C Box: 5 Amount : 7</P><P>Type: D Box: 6 Amount 8</P><P></P><P>in this above data, the total box will be 2 + 3+5+6 = 16</P><P></P><P>The formula to dervice is</P><P></P><P>(BOX/ TOTAL BOX) * Amount = Result 1</P><P></P><P>Then sum all the result from the above formula to get the weighted average, how do i do it with this complxity. thank you</P></BODY></HTML> Tue, 23 Apr 2013 02:13:40 GMT https://community.qlik.com/t5/QlikView/Weighted-Average/m-p/387965#M144758 n1ef5ng1 2013-04-23T02:13:40Z