grand total on form

[eka24]

Please can anyone help me get this grand total correct.
Qty price total
1 2000 2000
6 200 1200

Grand Total =sum([total]) not working. The grand total should be 3200 on the form footer

thank you

 

[pbaldy]

If total is calculated on the form, you'd need to sum the calculation.

 

[eka24]

yes, total is a calculated textbook qty*price which gives the total. grand total is therefore summing the total.

 

[missinglinq]

Then you need

=sum([qty]*[price])

Linq ;0)>

 

[pbaldy]

I'll get out of the way.

 

[eka24]

thanks Paul. works fine