Calculate percent for values in detail section

[Hallgeir]

In addition. to the detail section with "District", I have one group section
"Country".
My report looking something like this:

----------------------------------------
Country District Amount Percent
----------------------------------------
Norway
A 8 80%
B 2 20%
Sweden
B 4 40%
C 3 30%
D 3 30%

My problem is the Percent column. I want to show amount in percent for each
Country. Hope you understand what I mean. Appreciate any suggestions.

 

[Duane Hookom]

Try create a text box in the Report Header section:
Name: txtRptAmt
Control Source: =Sum([Amount])
Add a text box to the Country Group Header
Control Source: =Sum([Amount])/txtRptAmt
Format: Percent

 

[Hallgeir]

Thank you Mr Hookom. My problem was actually to calculate the percent in the
detail section, but your description solved my problem anyway.