ACCS - Report Averages Dont add up

[bucky101]

Hey Guys,

Any idea why my Grand Totals dont line up with my calculator? See attached, adding up the time values/percentage values and dividing by 4 does not work out

[hunte99]

For some reason, the forum isn't letting me see the attached image. Any chance you could upload to another site - like imgur or Photobucket - and link to it?

[mkopiec]

The math does not work correctly when you try to average things that were already averaged. In order to get the correct result for the grand total you need to work with the raw data, which is what the report does by default. The grand totals provided on the report are the correct totals based on the raw data.

[rsanches]

Spam, spam, spam