Percent to Total

[gholly]

hi! ...need help desperately. i am trying to enter a calculation which would
essentially be "% to Total". I used =[Units]/Sum([Units]) The problem though
that I'm having is the it is using the Sum of the total units from the whole
report, and not just for that "group" or actually "year". basically, is there
some sort of expression where I can say units divided by sum of units for the
same year? i'm not sure if this makes sense, or if you need more details on
my data. I hope someone is there to help me! Thank you in advance!!!

 

[Marshall Barton]

hi! ...need help desperately. i am trying to enter a calculation which would
essentially be "% to Total". I used =[Units]/Sum([Units]) The problem though
that I'm having is the it is using the Sum of the total units from the whole
report, and not just for that "group" or actually "year". basically, is there
some sort of expression where I can say units divided by sum of units for the
same year?

Use a text box (named txtGrpUnits) in the year group's
header section with the expression =Sum([Units])

Then the detail text box can use the the expression:
=[Units] / txtGrpUnits