How Do I perform calucalations on a calculated value in a report?

[jbseryan]

I have summed a series of records in one grouping in my report. In the next report level, I calculate a sub-total and perform a rounding and sig-fig operation on that value. In the final report level, I want to total the calculated sub-totals, but I can only total the original data points. HELP!

 

[jebry]

Hi!

You need to wrap your original calculations in the Sum function, like this:

=[Price]*[Amt]

In the group or report footer to get the grand total

=Sum([Price]*[Amt])

hth
Jeff Bridgham
bridgham@purdue.edu