Grand Total Calculation (1 Viewer)

[Manic_Rach]

Hey guys, just a quick question,

I have a report displaying ordered items. The fields shown are [item number], [item name], [units ordered] and [unit price].

In the report design view I've created a calculation so that for every item there is a subtotal using this code:

=[units ordered]*[unit price]

What I want is a "Grand total" in the footer at the bottom of the report. I've tried using:
=sum([subtotal])
but i get "ERROR#" in the box and it sayd the field doesnt exist. I don't understand why Sum doesnt work when
=[subtotal]
gives me a value for the last item in the list.

If the text box with the subtotals in is named "subtotal" and the equation works without "sum" in the equation then surely it recognises the field name as an existing field and "sum" should work? Right?

 

[Beetle]

You can't use the name of a calculated control like this inside the Sum function. You need to Sum the original calculation;

=Sum([units ordered]*[unit price])

 

[Manic_Rach]

Hey, I'vetried that and it still comes up with Error# in the text box on the report

 

[Beetle]

Where are you putting the text box for the Grand Total?

It needs to be in the Report footer, not the Page footer.