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.