|I'm in a report, collecting counts of different case types for individual employees. Each employee has a total number, which is then broken into three categories and this report is run on a weekly basis. Right now, everything is working fine but management wants an average of each employee's week, vs the overal count of all cases worked divided by the number of employees.|
So, Jane Doe's report would look like this:
Total all employees 127
Num employees 26
So Jane here is a little behind the others.
What I've been trying is to use the Avg function like this ='avg([AccessTitaksDate Taken2]) (which is the name of the field with the employee's totals) and ='avg(count([Date Taken]) and avg(Count([AccessTotalsDate Taken2])). I am persistently getting the same error message:
Cannot have aggregate function in expression (Avg(Count([AccessTotalsDate Taken2])))
Short of creating a module, I'm not sure what else to do. This HAS to be possible, right? So what should I do now?