+ Start a Discussion

apply discount either in $ or %

I have the fields "Base_Price__c", Discount_Percentage__c, Discount_Amount__c.  I need to calculate the discounted price either by $ or percentage.  I need some help to write a formula to have either one discount or no discount, please help
Best Answer chosen by mw6
I assume you will have either Discount_Percentage__c or Discount_Amount__c populated in your records, not both of them.

Try this formula.
IF(Discount_Amount__c > 0, Base_Price__c - Discount_Amount__c, IF(Discount_Percentage__c > 0, Base_Price__c * (100 - Discount_Percentage__c) / 100 ,Base_Price__c))
Let me know if this helps.