Apex Code Development You need to sign in to do that
Don't have an account?
RRES Calculating Discounted Amount
I am trying to create a calc field that discounts the Opportunity amount field if the amount is greater than a specific value.
For example:
If Opp_Amount > $10,000 then discount is equal 20%. So the value in the field will equal 10,000 x .20.
Because there are multiple discount levels it will have to evaluate multiple if statements. If none of the statements apply then the value would remain equal to the Opp_Amount.
Can this be done using a calculating field? If so how would I arange the if,else statements.
Thanks
as I understand this it would works as follows.
new field > type formula > to store this formula
IF({!opp_amount__c} > 10000, {!opp_amount__c} * 0.2,
IF({!opp_amount__c} > 8000,{!opp_amount__c} * 0.1,
{!opp_amount__c} * 0.05))
so its basically if the value in opp_amount is greater than 10000 the use 0.2
else if less than 10000 but greater than 8000 then use 0.1, for everything else (ie will be less than or equal to 8000) use 0.05.
you can keep adding the else if statments. you will need to work down through the numbers ie start at the highest number then work down. in the example it starts at 10000 then 800 then ...
I hope this helps
Gareth
It can be most usful even.
http://crmsuccess.blogs.com/files2/100_sample_formulas_v6.pdf