I have a report that has serveral groups etc. There are two cross tab reports, one at a group level and another in report footer.

Report with groups:
Group 1 - Department
Group 2 - Question status Failed or Passed,
Group 3 - Employee ID

I create two summary fields in the report – one called Failed Count and one called Passed count (which is counting the employee id on each change in the group 3 )

I inserted these two fields into a cross tab.

I need to insert one more formulas that takes the grand total of the failed count and passed count (by department, failed, employee id) divided by the failed count ( by department, failed, employee id) = failed percent.

Any help is GREATLY appreciated!!

Cervello