Group subtotals need to use report totals

[Guest]

Hello

I have a report that is grouped on Security Maturity Dates. I have to caclulate the percentage of total portfolio value maturing on every date. So, I need to divide the subtotal "Sum([PrincipalDue])" appearing in the group fooeter of Security Maturity date by the "Sum([PrincipalDue])" appearing in the report footer

This, of course, does not work

Does anyone know how I can get it to work

Much thanks in advance
Nick

 

[Duane Hookom]

Try add a text box to the Report Header
Name: txtRptTotal
Control Source: =Sum([PrincipalDue])

Then in your group footer try
Control Source: =Sum([PrincipalDue])/txtRptTotal

--
Duane Hookom
MS Access MVP
--

Hello,

I have a report that is grouped on Security Maturity Dates. I have to

caclulate the percentage of total portfolio value maturing on every date.
So, I need to divide the subtotal "Sum([PrincipalDue])" appearing in the
group fooeter of Security Maturity date by the "Sum([PrincipalDue])"
appearing in the report footer.