grand total on form (1 Viewer)

E

eka24

Registered User.

Local time

Today, 08:46

Joined

Oct 2, 2017

Messages

41

• Jan 12, 2018

• #1

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

Wino Moderator

Staff member

Local time

Today, 08:46

Joined

Aug 30, 2003

Messages

36,125

• Jan 12, 2018

• #2

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

 

E

eka24

Registered User.

Local time

Today, 08:46

Joined

Oct 2, 2017

Messages

41

• Jan 12, 2018

• #3

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

 

missinglinq

AWF VIP

Local time

Today, 11:46

Joined

Jun 20, 2003

Messages

6,423

• Jan 12, 2018

• #4

Then you need

=sum([qty]*[price])

Linq ;0)>

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 08:46

Joined

Aug 30, 2003

Messages

36,125

• Jan 12, 2018

• #5

I'll get out of the way.

 

E

eka24

Registered User.

Local time

Today, 08:46

Joined

Oct 2, 2017

Messages

41

• Jan 12, 2018

• #6

thanks Paul. works fine