% of Group Footer Over Report Footer Totals 1

[awl]

I have searched some of the threads and the answer is not clear. I have a Group Footer called Subtotals of Exams and Report Footer called Grand Total of Exams. I would like to display the “Percentages” of Subtotals of Exams over Grand Total of Exams. In my B formula below, the result for each Group Footer is 100%, which is not what I want. The following are the controls in the Group Footer and Report Footer Sections, and Group Footer Subtotals.

A. SubTotal of Type of Exam (label for control in Group Footer Section)
=Sum([SumOfCountOfTypeOfJobTitleRpt])

B. Percentages of Total Exams (label for control in the Group Footer Section)
=(Sum([SumOfCountOfTypeOfJobTitleRpt])/(Sum([SumOfCountOfTypeOfJobTitleRpt])))*1

C. Grand Total of Type of Exam (label for control in Report Footer Section)
=Sum([SumOfCountOfTypeOfJobTitleRpt])

Group Footer 1 = 38, Group Footer 2 = 120, Group Footer 3 = 217, and Group Footer 4 = 457; Grand Total = 832 Exams. Each Group Footer displays 100%; my understanding is that the formula is 38/38, which is 100%. I am looking for 38/832, which is 5%.

Can someone enlighten me as to what my error is? Thank you.

 

[ptpaton]

The easiest way to do something like this is to name your text boxes and do the math based on the names of the controls. Call your group footer control "txtSubtotal" and your report footer control "txtTotal"

Then, in the group footer, create a new text box with this expression as the control source.

=[txtSubtotal]/[txtTotal]

Format it to percent and you're done.

Let me know if this works!

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[awl]

Patrick: Your short explanation was well worth the effort. I did as suggested and it worked. After I changed the names to both Group Footer and Report Footer, I used the following control: =([txtSubTotalTypeExam]/[txtGrdTotalTypeExam])*1 Thank you very much. Curtis...