topic Re: top 10 average is not calculated correctly in QlikView https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412050#M426913 <HTML><HEAD></HEAD><BODY><P>Its not working as its Top 10 city pairs</P></BODY></HTML> Sat, 02 Dec 2017 10:13:31 GMT alis2063 2017-12-02T10:13:31Z top 10 average is not calculated correctly https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412048#M426911 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have produced the Advanced purchased report &amp; wanted to calculate the Average Fare</P><P></P><P>Avg Fare= '<STRONG>0-4 Day Total $$/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>0-4 Day Sectors' </STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>Its working for City pairs but total Calculation is getting wrong</STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 13.3333px;"><STRONG>I.e 647,425/995=650.1 -Is correct </STRONG></SPAN></P><P>&nbsp;&nbsp; <STRONG>&nbsp; 7473422/11087 </STRONG> <STRONG> 979 <SPAN style="color: #ff0000;">is wrong</SPAN></STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG><BR /></STRONG></SPAN></P><P></P><P></P><P>!<IMG alt="Avg Fare.png" class="jive-image image-1" src="/legacyfs/online/185470_Avg Fare.png" style="height: 497px; width: 620px;" /></P></BODY></HTML> Sat, 02 Dec 2017 09:59:14 GMT https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412048#M426911 alis2063 2017-12-02T09:59:14Z Re: top 10 average is not calculated correctly https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412049#M426912 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P><STRONG>=sum(aggr( 0-4 Day Total $$/</STRONG><SPAN style="font-size: 13.3333px;"><STRONG>0-4 Day Sectors, CityPair))<BR /></STRONG></SPAN></P></BODY></HTML> Sat, 02 Dec 2017 10:07:07 GMT https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412049#M426912 Kushal_Chawda 2017-12-02T10:07:07Z Re: top 10 average is not calculated correctly https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412050#M426913 <HTML><HEAD></HEAD><BODY><P>Its not working as its Top 10 city pairs</P></BODY></HTML> Sat, 02 Dec 2017 10:13:31 GMT https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412050#M426913 alis2063 2017-12-02T10:13:31Z Re: top 10 average is not calculated correctly https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412051#M426914 <HTML><HEAD></HEAD><BODY><P>Would you mine, Can you share sample to test</P></BODY></HTML> Sat, 02 Dec 2017 11:18:19 GMT https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412051#M426914 Anil_Babu_Samineni 2017-12-02T11:18:19Z Re: top 10 average is not calculated correctly https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412052#M426915 <HTML><HEAD></HEAD><BODY><P>Pease look into snapshot</P></BODY></HTML> Tue, 05 Dec 2017 13:57:02 GMT https://community.qlik.com/t5/QlikView/top-10-average-is-not-calculated-correctly/m-p/1412052#M426915 alis2063 2017-12-05T13:57:02Z