topic Re: incorrect Avg roll up in QlikView https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416287#M459415 <HTML><HEAD></HEAD><BODY><P>May be try with <STRONG>Avg(Aggr(Expression, Dimension/s))</STRONG></P></BODY></HTML> Tue, 26 Sep 2017 14:20:04 GMT sunny_talwar 2017-09-26T14:20:04Z incorrect Avg roll up https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416285#M459413 <HTML><HEAD></HEAD><BODY><P>I have a pivot country/ category by service years with avg hourly $rate .... total line not averaging correctly. what could be the problem any suggestions?</P><P><IMG alt="avg.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177764_avg.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 26 Sep 2017 14:12:32 GMT https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416285#M459413 rmuhammad 2017-09-26T14:12:32Z Re: incorrect Avg roll up https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416286#M459414 <HTML><HEAD></HEAD><BODY><P>Instead 9.34 it should show 11.08 $. Isn't it?? Will you able to provide exxpression you used..</P></BODY></HTML> Tue, 26 Sep 2017 14:19:47 GMT https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416286#M459414 Anil_Babu_Samineni 2017-09-26T14:19:47Z Re: incorrect Avg roll up https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416287#M459415 <HTML><HEAD></HEAD><BODY><P>May be try with <STRONG>Avg(Aggr(Expression, Dimension/s))</STRONG></P></BODY></HTML> Tue, 26 Sep 2017 14:20:04 GMT https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416287#M459415 sunny_talwar 2017-09-26T14:20:04Z Re: incorrect Avg roll up https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416288#M459416 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">Avg(Total Aggr(Sum([Service Years]),<SPAN style="color: #ff0000;">country_category</SPAN>))</SPAN></P></BODY></HTML> Tue, 26 Sep 2017 14:22:07 GMT https://community.qlik.com/t5/QlikView/incorrect-Avg-roll-up/m-p/1416288#M459416 Anonymous 2017-09-26T14:22:07Z