topic Re: AVG() Not Returning Expected Results in QlikView https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444261#M487134 <HTML><HEAD></HEAD><BODY><P>Spot On.</P><P></P><P>Interval worked.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 18 Feb 2013 10:39:23 GMT Anonymous 2013-02-18T10:39:23Z AVG() Not Returning Expected Results https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444259#M487132 <HTML><HEAD></HEAD><BODY><P>I have a straight chart, with call numbers and turnaround times.</P><P></P><P>I'm trying to calculate the average, with a straight - avg() and it's producing a strange result.</P><P></P><P>I've tried sum(total turnaround) / count(distinct call no) - same result.</P><P></P><P>Bit stumped now.</P><P></P><P>Any help greatly appreciated.</P><P></P><P>File attached.</P></BODY></HTML> Mon, 18 Feb 2013 10:31:23 GMT https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444259#M487132 Anonymous 2013-02-18T10:31:23Z Re: AVG() Not Returning Expected Results https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444260#M487133 <HTML><HEAD></HEAD><BODY><P>When you say Strange Result.. do you mean a decimal value?</P><P>In that case, try using the function Time() or Interval() around your expression to format it as a time portion of a timestamp.</P></BODY></HTML> Mon, 18 Feb 2013 10:36:14 GMT https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444260#M487133 Anonymous 2013-02-18T10:36:14Z Re: AVG() Not Returning Expected Results https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444261#M487134 <HTML><HEAD></HEAD><BODY><P>Spot On.</P><P></P><P>Interval worked.</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 18 Feb 2013 10:39:23 GMT https://community.qlik.com/t5/QlikView/AVG-Not-Returning-Expected-Results/m-p/444261#M487134 Anonymous 2013-02-18T10:39:23Z