Percentage Calculation Help

[Zonie32]

Hello. I have a report based on a qry where the report is grouped by LineOfBusiness field and it Counts the number claims per Line of business.

Now in my report I want to take the grand total of all claims which I have as =Sum([CountofClaims]) and I want to get a percentage per Line of Business.
So take Grand Total divided by CountOfClaim

ex
LOB CountOfClaims PctofClaim
ICIAAA 10 16.7%
ICIBBB 20 33.3%
ICICCC 30 50.0%
Grand total 60
I added to my report a text box and put in there
=Sum([CountOfClaim]/[CountOfClaim]) and it just comes up with 100% for each LineOfBusiness. Can someone help with this formula.

 

[mgolla]

Change it to:

= ([CountOfClaims]/[txtGrandTotal])*100


Where txtGrandTotal is your Grand Total Field

HTH
Mike

 

[Zonie32]

Thanks for the quick response. I am still having a bit of a problem.

My report is set up where I have an LOB Header where it shows LOB and CountofClaim. Then I have a Report Footer where I inserted a label that says GrandTotal and next to it i have =Sum([CountofClaim]).

I am trying to put the Percentage in the LOBHeader so each pct ends up next to the LOB. So here is what I entered:
=([CountofClaim]/[txtSum([CountofClaim])*100. It says "Invalid bracketing of name [txtSum([CountofClaim]".
Can I not put a calculation in the LOB Header? Is that the problem? I'm sorry, I am not very good with access, but I am learning!