function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mw6mw6 

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
LBKLBK
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.