(100-DiscountRate)/100 * RegularPrice is the calculation for DiscountPrice
DiscountRate is a decimal with decimal set to blank Example input 15
RegularPrice and Discount Price is Currency with decimal set at 2
RegularPrice Example $100.00
DiscountPrice Example $85.00
If you prefer the style of your original calculation, try this:
( (AdType1 * Price1) + (AdType2 * Price2) ) * (100 - Rebate) / 100
Awesome! That did the trick :))) Thanks a lot for your help guys - really saved me on the line !