Originally posted by DBlankStill confused as to where you are summing these...
(RT1*X) is a value per row (detail level)
@TOTAL SUM is at a group level?
SUM(@total_sum) is for the report footer?
Let me break it out a little more. This might help explain. I have a separate report for each person.
Details: (All "details" sections are suppressed)
Group1 Amount (custom formula)
R1 10
R2 10
R3 10
S1 10
S2 10
S3 10
Footer: (I'm using RT's to sum by group and reset after each new change in group.)
R Total for John Doe: 30
S Total for John Doe: 30
Then I'm taking the R Total and S Total for John Doe and multiplying it by a factor that is based on the Group label.
Custom formula for R Total for John Doe: 65.123
Custom formula for S Total for John Doe: 19.5264
Since I do this for each person, every employee has a single page report with the above info. I'd like to create a page at the end of this report that will sum all of the Custom formula R Totals and S Totals for everyone.