How to Show Results of Cost * Discount % Then Deduct The Discount In Same Text Box? (1 Viewer)

MBM

Registered User.
Local time
Today, 14:04
Joined
Sep 27, 2010
Messages
31
txttotal (text box that outputs sum of two fields)
=Sum([Quantity]*[Cost])

txtdiscount (multiplies sum of two fields * 7%)
=[txttotal]*0.07

How do I show the sum of the two fields with the 7% discount in the txtdiscount text box?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:04
Joined
Aug 30, 2003
Messages
36,125
Does this work?

=Sum([Quantity]*[Cost]) * .93
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:04
Joined
Aug 30, 2003
Messages
36,125
Happy to help!
 

Users who are viewing this thread

Top Bottom