Getting an Average from a group summary formula
Posted on 2012-04-05
I have a report that is grouped by Department which lists employee production metrics and hours worked. I use a simple formula to generate their work output, known as Lines Per Hour, which is essentially Lines/Hour just as it reads. For the Department footer I have a subtotal which has the Lines/Hour for the department and use a similar formula to reach that number. I would like to also generate an Average Lines/Hour but I am unable to summarize a summary field due to the way Crystal processes the report.
I understand there is some sort of two pass system to crunching formulas in Crystal but never having dealt with the "second pass" I'm a little unsure how to proceed with doing this. Any help would be appreciated.