D
DJFreebird
Situation: Many employees and many different positions, but there are a lot
of the same positions. Each position requires different types and different
amounts of certifications in order to be in the job position. I am
generating a report to show what percentage they are to their job position
(with all certifications, a person is 100% compliant)
In order to do this, I separated the job positions out into 6 categories,
and created 6 different reports. I used these as subreports so that I could
show all employees under the same supervisor, but with different criteria.
The main report separates the subreport by their supervisor and shows all
employees under that supervisor, and the sorting/grouping keeps the positions
together in order to make a very attractive report.
Each subreport as a hidden field in the report footer with the average
percentage of "compliance" for that category.
How can I take the fields in the report footers of all 6 subreports and get
a total average of percentage to "compliance" per supervisor? Every time I
try to average them, I just get #Error.
of the same positions. Each position requires different types and different
amounts of certifications in order to be in the job position. I am
generating a report to show what percentage they are to their job position
(with all certifications, a person is 100% compliant)
In order to do this, I separated the job positions out into 6 categories,
and created 6 different reports. I used these as subreports so that I could
show all employees under the same supervisor, but with different criteria.
The main report separates the subreport by their supervisor and shows all
employees under that supervisor, and the sorting/grouping keeps the positions
together in order to make a very attractive report.
Each subreport as a hidden field in the report footer with the average
percentage of "compliance" for that category.
How can I take the fields in the report footers of all 6 subreports and get
a total average of percentage to "compliance" per supervisor? Every time I
try to average them, I just get #Error.