Error on Report

[Guest]

I created a report and wanted a Sum of some of the numbers. It works fine
when the calculation is in the Detail section of the report, but when I move
the calculation into the Footer section where I want it to be it returns
"#error". I tried moving it around to see if I would get an error and it
worked in the Report Header section but returned the error in the Page Header
section. Does anyone have any idea why it won't calculate in the Page
Footer? Thanks.

 

[Duane Hookom]

The Sum() and other aggregates don't work in Page Headers or Footers. You
can use the Report Footer for your totals.

 

[Guest]

try using groups in your reports, in the group footers you can use the sum()
function as well