2 Replies Latest reply: Feb 18, 2013 5:39 AM by Phill Gilchrist RSS

    AVG() Not Returning Expected Results

    Phill Gilchrist

      I have a straight chart, with call numbers and turnaround times.

       

      I'm trying to calculate the average, with a straight - avg() and it's producing a strange result.

       

      I've tried sum(total turnaround) / count(distinct call no) - same result.

       

      Bit stumped now.

       

      Any help greatly appreciated.

       

      File attached.