I am looking for some help with a formula field. Im not sure if it is totally possible. I think it should be, but what do I know. I currently have this operating using Process Builder and it works most of the time, but sometimes I run into issues "Too many SQL Queries" or sometimes it just doesn't run the flow....
I have some calculations that need solved in order to come up with a final cost for my customers and ultimately to track the Opportunity Values based on fields that are filled in.
Here is what I have so far. I think it works but the value it is returning is TEXT instead of currency. Additonally I need 9 Total OR statements to make this replace the Process that sometimes works.
Any help would be greatly apprectiated. Thanks in advance!
IF(AND( ISPICKVAL( Base_Package__c , "ENTERTAINMENT"), ISPICKVAL( Programming__c , "CHOICE ADD-ON")), "25", "0")
Additonal Values that need to be calcuated as OR statements in this same field.
IF Base_Package__c = ENTERTAINMENT AND Programming__c = XTRA ADD-ON, 25, 0
IF Base_Package__c = ENTERTAINMENT AND Programming__c = UTLIMATE ADD-ON, 25.50, 0
IF Base_Package__c = ENTERTAINMENT AND Programming__c = PREMIER ADD-ON, 23, 0
IF Base_Package__c = CHOICE AND Programming__c = XTRA ADD-ON, 37, 0
IF Base_Package__c = CHOICE AND Programming__c = ULTIMATE ADD-ON, 36.50, 0
IF Base_Package__c = CHOICE AND Programming__c = PREMIER ADD-ON, 34, 0
IF Base_Package__c = XTRA AND Programming__c = ULTIMATE ADD-ON, 50, 0
IF Base_Package__c = XTRA AND Programming__c = PREMIER ADD-ON, 49, 0
11 answers
If they're both Picklist or Text fields you could use a Nested CASE like this
CASE( Base_Package__c
"ENTERTAINMENT",
CASE(Programming__c,
"CHOICEADD-ON",25,
"XTRA ADD-ON",25,
"UTLIMATE ADD-ON",25.50,
"PREMIER ADD-ON",23,
0),
"CHOICE",
CASE(Programming__c,
"XTRA ADD-ON",37,
"ULTIMATE ADD-ON",36.5,
"PREMIER ADD-ON",34,
0),
"XTRA",
CASE(Programming__c,
"ULTIMATE ADD-ON",50,
"PREMIER ADD-ON",49,
0),
0)
