% of two sum totals

[Mike Hughes]

Trying to create a new column in report to figure the % of collections to the sum of all collections for each district. Please see attachment. Thanks Mike

 

[Alansidman]

Here is a solution that you can use in a query. Then make the query your record source for your report.

http://www.datapigtechnologies.com/flashfiles/percenttotal.html

 

[Mike Hughes]

I can't do this in a query it needs to be done in the report. See another screenshot I have attached.

 

[Mike Hughes]

Let me try and explain this again with more pictures. I have severall offices with a total collected field. In the report footer I have totaled the column (=sum([COLLECTIONS]). I would like to add another column to the report which would give the the % for each line of COLLECTIONS compaired to the total collections. See more attached photos please. Thanks Mike

 

[GaryPanic]

whats the field called that = (=sum([COLLECTIONS]). say its fieldX


then its value/fieldx*100


should do it

 

[Mike Hughes]

I figured it out. Thanks for taking the time to look. Mike

=[COLLECTIONS]/Sum([COLLECTIONS])