PDA

View Full Version : Need to turn A percentage into dollar amount


ABC123

sbatrez5
03-16-2011, 01:49 PM
Now that i have the discount in my browse bar I need to have it converted to dollars in a separate field, so that my customers can see how much of a discount they are getting. I need it to total all of the products that have a Discount.

Stan Mathews
03-16-2011, 02:05 PM
We did this to get the extension for a line item

QUANTITY*PRICE*(1-(Discount/100))

The discount in dollars for a line item would be

QUANTITY*PRICE*(Discount/100)

The total for an invoice (as shown on a form) would be

tablesum("invoice_items","invoice_number ="+quote(invoice_number.value),"QUANTITY*PRICE*(Discount/100)")


I need it to total all of the products that have a Discount.

If they don't have a discount the discount will be zero and totaling all the records for an invoice is easier than just those with a discount. The total will be the same.

sbatrez5
03-18-2011, 02:40 PM
Thanks