Total in Report Footer

[Duane Hookom]

Do you mean the Report Footer of possibly a group or page footer? "Txt...."
sound like text boxes. Are these in the same section as you want to display
the percent?

What is the difference between "percentage field" in a report footer and
"total percentages" on the report footer of the report?

Do you have any field names, usages, and calculations that you could share
with us?

 

[DS]

I have this field called TxtPCT in a footer section of a report.
=[TxtCNT]/[TxtGTCNT]
its a percentage field.

I'm trying to get the total percentages on the report footer
of the report.

I tried this...
=Sum([TxtCNT/[TxtGTCNT])
No Luck

I tried this...
=[TxtCNT]/[TxtGTCNT]
No Luck

I tried...
=Sum([TxtPCT])
No Luck

I tried...
=Sum([TxtCNT])/Sum([TxtGTCNT])
No Luck

Any help is appreciated.
Thanks
DS

 

[DS]

Do you mean the Report Footer of possibly a group or page footer? "Txt...."
sound like text boxes. Are these in the same section as you want to display
the percent?

What is the difference between "percentage field" in a report footer and
"total percentages" on the report footer of the report?

Do you have any field names, usages, and calculations that you could share
with us?

Its a calculated field on a group footer and I want to total it on the
report footer.

Group Footer
TxtPCT = TxtCNT/TxtGTCNT

Report Footer
TxtGTPCT = Sum(TxtCNT/TxtGTCNT

Thanks
DS

 

[Duane Hookom]

You can't sum controls across report sections. That's why I asked

 

[DS]

You can't sum controls across report sections. That's why I asked

OK I did this I added an invisible running sum textbox for each section
and also put it in the report footer, I then used this number along with
the visible number to get my 100%.
DS