Percent to Total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
gholly said:
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?
Click to expand...


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
 
Back
Top