Calculations in a Report

[Guest]

I have created a report that tracks timesheet hours. I want to total one of
the columns. The column is Billable hours (numeric field in my table). I
put a text box with the calcuation "=sum([billable hours]) in the footer
section.

All I can get is a #Error. Any ideas appreciated.

 

[John Vinson]

I have created a report that tracks timesheet hours. I want to total one of
the columns. The column is Billable hours (numeric field in my table). I
put a text box with the calcuation "=sum([billable hours]) in the footer
section.

All I can get is a #Error. Any ideas appreciated.

It needs to be in the Report footer, or in the footer of a Sorting and
Grouping section. It will *not* work in the Page Footer.

John W. Vinson[MVP]