AVG() Not Returning Expected Results

[Anonymous]

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.

[Anonymous · Accepted solution]

When you say Strange Result.. do you mean a decimal value?

In that case, try using the function Time() or Interval() around your expression to format it as a time portion of a timestamp.

[Anonymous]

Spot On.

Interval worked.

Thanks.