topic AVG does not return what I calculate as the average in QlikView https://community.qlik.com/t5/QlikView/AVG-does-not-return-what-I-calculate-as-the-average/m-p/20398#M784277 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have a dataset with several duplicate records. I am trying to calculate an average response time to an incident. Each incident has a separate response time but where the record is duplicated the response time is also duplicated. I am dealing with this by using DISTINCT</P><P></P><P>My table calculates the total response time for each category and calculates the number of distinct records.</P><P></P><P>I calculate the average by dividing one by the other.</P><P></P><P>however since I need to calculate the 90th percentile also I checked the maths by using avg. it provides a different answer.</P><P></P><P>what is going wrong and how do I fix it please?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196205_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT steveniow 2020-11-25T16:16:04Z AVG does not return what I calculate as the average https://community.qlik.com/t5/QlikView/AVG-does-not-return-what-I-calculate-as-the-average/m-p/20398#M784277 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I have a dataset with several duplicate records. I am trying to calculate an average response time to an incident. Each incident has a separate response time but where the record is duplicated the response time is also duplicated. I am dealing with this by using DISTINCT</P><P></P><P>My table calculates the total response time for each category and calculates the number of distinct records.</P><P></P><P>I calculate the average by dividing one by the other.</P><P></P><P>however since I need to calculate the 90th percentile also I checked the maths by using avg. it provides a different answer.</P><P></P><P>what is going wrong and how do I fix it please?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196205_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/AVG-does-not-return-what-I-calculate-as-the-average/m-p/20398#M784277 steveniow 2020-11-25T16:16:04Z Re: AVG does not return what I calculate as the average https://community.qlik.com/t5/QlikView/AVG-does-not-return-what-I-calculate-as-the-average/m-p/20399#M784278 <HTML><HEAD></HEAD><BODY><P>Average can be tricky... look here for why <A href="https://community.qlik.com/qlik-blogpost/3208">Average – Which average?</A></P></BODY></HTML> Tue, 13 Mar 2018 16:26:56 GMT https://community.qlik.com/t5/QlikView/AVG-does-not-return-what-I-calculate-as-the-average/m-p/20399#M784278 sunny_talwar 2018-03-13T16:26:56Z