Having a real problem with totaling ...

I am going through employee records from a temporary database table. The detail records on the report are suppressed. I have a field called 'match' in each detail record. I have a group for each employee. At the group level I have an average of the 'match' field. So far, everything works just great.

At the report footer I want a total of those group averages. I cannot, for the life of me find a way to do that! I can't sum it. I tried using formulas and when I get to X := X + @averagefield, I am told the field cannot be summed.

I am very close to saying screw Crystal and write something in my VB code to move the average and emp# to a temporary table and link to that on the report. I am sure there is a way to do this, I just don't know how.

PS. It is Crystal Reports 9.2.3

How about totaling the "match" field? In terms of math, what would totaling the averages tell you? If one groups has 100 samples and an average of 5 and another group has 2 samples and an average of 10, what does adding them together tell you?

Quote:

---

Originally Posted by wes4dbt

How about totaling the "match" field? In terms of math, what would totaling the averages tell you? If one groups has 100 samples and an average of 5 and another group has 2 samples and an average of 10, what does adding them together tell you?

---

Say there are 100 employees. Each one has 5+ records. I show the employee group with the average of field 'match', not the detail record. I want a total of those group records. So if each employee had an average of $5 the total would be $500. Without the average, it might be $2500+

I can't get a total of an average field.