Average Problem???

[kovas]

I am trying to do an average on a formula

@Hours

DateDiff("s", {StartTime}, {EndTime})

its 4 recs with results

14,400
10,800
10,800
10,800

When I right click and try to insert a Summary or Running total with the calculation of Average, I get 11,011.76 when it should be 11,700.

Anyone have any idea why the average comes out wrong?

thank you

 

[kovas]

Never mind, found out the problem, was evaluating for each record and not when group was reset in the Running total