Having a real problem with totaling ...

[Pasvorto]

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

[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?

[Pasvorto]

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.