Isn't the discount price, in this case -10% simply a calculation:
Regular Price * .9
Or am I contracting you're brain fart too?
Yes Steve, I believe the Discount Price field is a calculation field. I just need to know what goes inside of it.
1 of 1 people found this helpful
regularPrice * ( 1 - discount / 100 )
Thank you for this Erolst. Worked flawlessly.
A great answer but I have another question. How would I make the number round up to the nearest 5 or 10?
Round to Nearest 5 cents
discountprice = Round ( price * ( 1 - discount/100 ) * 2 ; 1 ) / 2
e.g. price = 9.90, discount = 7.5 , discountprice = 9.15 (unadjusted = 9.16)
Round Up to Next 5 cents
discountprice = Round ( price * ( 1 - discount/100 ) * 2 + .04 ; 1 ) / 2
e.g. price = 9.90, discount = 7.5, discountprice = 9.20 (unadjusted = 9.16)
Note: for 0% discount, discountprice = original price to nearest/next 5 cents