You need to sign in to do that
Don't have an account?
Help with Currency Formula
I need a currency formula field that returns a currency value based on selections in 2 other picklist fields. The formula should work like this:
IF value "x" is selected in picklist 1, and value "x" is also selected in picklist 2, THEN, the formula should return the Amount of the opportunity.
I think the currency formula would look something like this:
---------------------
IF(
AND(
ISPICKVAL(PracticeArea__c, "DI (Defense/Intelligence)"),
ISPICKVAL(Supporting_Practice_1__c, "DI (Defense/Intelligence)")),
Amount)
---------------------
Obviously something is wrong with the syntax but I can't figure it out. Any ideas?
You're almost there, you just need to close it out with an Else result (what do you want the formula to do if the condition is NOT true)
Here are some tip sheets on creating Formlua fields
https://na2.salesforce.com/help/doc/en/salesforce_formulas_cheatsheet.pdf
https://na2.salesforce.com/help/doc/en/salesforce_useful_formula_fields.pdf
Try this. If any of the conditions are not true, the formula returns 0
IF(AND(
ISPICKVAL(PracticeArea__c, "DI (Defense/Intelligence)"),
ISPICKVAL(Supporting_Practice_1__c, "DI (Defense/Intelligence)")),Amount, 0)