Avg Function Not producing expected results

[vijayUV]

I have a data set that has the following information 

Sum(TAT) = 8635

Count(TAT) = 2

When I do an average either using Avg function or SUM/Count my expected value is  4317.5

But for some reason, I am getting, 179.89

Can someone help me with this weird issue?

Many Thanks.

[Anil_Babu_Samineni]

What you've tried? 

1) Avg(TAT)

2) Sum(TAT)/Count(TAT)

[sunny_talwar]

Would you be able to share a sample where we can see this issue?

[vijayUV]

The data set hasDeptName, EmpName column and the TAT(Turn around Time in Hrs) columns, we are calculating the Min.TAT, Max.TAT and the Avg.TAT

Avg(TAT) function or Sum(TAT)/Count(TAT)

Both are giving results that are incorrect when I calculate manually. 

Can you please throw some light on this.

Thanks,

Vijay

[vijayUV · Accepted solution]

I have identified the issue,

My TAT column type is 'Interval in hrs' and the sum value is calculating the total value of the hrs but

the AVG function is considering this SUM value as a number, which is resulting in the wrong values. When I calculated the interval of the avg value it gives the exact values. 

The solution for my problem is -  Interval(Avg(TAT),'hh')