Group subtotals need to use report totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
--

NickM said:
Hello,

I have a report that is grouped on Security Maturity Dates. I have to
Click to expand...
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.
 
Back
Top