Sum in reports

[kicken18]

I have a report that is an invoice for a customers order. It displays the orders that the customer has placed and the cost of each order. At the bottom in the Page Footer i have put a text field with =sum([Cost] but all i get is #error and I have tried changing it to Running sum over group and all but i still get the #error. <a href="http://chris.sbd-clan.net/InvoiceDesign.JPG">Here</a> is a screen shot of the design and <a href="http://chris.sbd-clan.net/InvoiceOutput.JPG">here</a> is one for the output

Thanks
Chris

 

[KeithIT]

Try placing the code in the report footer

Have you tried placing the code in the report footer? Or is this something that needs to exist on each page?

 

[kicken18]

haha no idear why I didnt try that, thats been bugging me for ages now

Thanks alot
Chris