Summing section footers in a page footer

[Rik_StHelens]

I have a report which groups a set of information about transport fleet costs. After each grouping i used an unbound text box so the report calculates the total costs for a fleet of vehicles, and the average cost per vehicle in the grouping footer.

In the page footer i want to total the number of all vehicles, and then the total costs for all fleets, and work out an average cost for all vehicles, regardless of fleet.

I am having to use the text boxes in the group footers, or else it will return the wrong results.

I am using 3 formulae

=Sum([Text41])
=Sum([Text34])
=Sum([Text41])/([Text34])

but they all return #error


What am i doing wrong?

 

[Rik_StHelens]

Swapping "Sum" for "Cint" i have managed to get the text boxes to display a value.

BUT. it only displays the values for the final group footer, rather than adding up every group footer in the report.

what can i do to get this to add up?