Pivot Table Average of Count returning #DIV/0

[sqageek]

Hi,
I dont understand only why two specific columns are getting this issue. I have verified by going in to individual sheets and calculated the Average. No issues.

I am preparing a pivot with data from multiple sheets.
Please share your email so that i can send it to you if you wanna see the file

[stasinek]

In columns where there should be a date - there is always a date.
In columns where there should be time - there is not always time.
Check the data source and give the pivot table the correct values and you will have the correct results.

[sqageek]

Thank you. But the problem is not with the time related columns. IT is related to the other columns. Can anyone please check it once.

[sqageek]

I really don't understand whats happening with excel. I have formatted the columns to correct datatype "number" in all sheets. When i observed in Microsoft query it is showing that those columns in random sheets are of type DATETIME. It is happening once in 1st sheet, another time in other sheet.
How can i get rid of this problem.