I want to calculate “OrderTotal” by multiplying “Price” by “Quantity” minus “DiscountPercentage”
OrderTotal = (Price*Quantity)-DiscountPercentage
-- Price is already populated in the form and is a text box.
-- Quantity will be filled out by salesrep. (Should it be text box or unbound?)
-- DiscountPercentage will be filled out by salesrep as well and should be from 1 to 20. (Should it be a text box or unbound?)
How do I do this?
Thanks for your generosity in sharing the knowledge.