Sign Up ›

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

Bulk-iky Formula


Can someone help me figure out how to reduce this formula with CASE? I just don't know how to finish the rest....


IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 25000 && Total_Amount__c < 49999 &&  AND (ISPICKVAL( Months__c, "24-Months")) , 0.04524,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 25000 && Total_Amount__c < 49999  &&  AND (ISPICKVAL( Months__c, "36-Months")) , 0.03135,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 25000 && Total_Amount__c < 49999  &&  AND (ISPICKVAL( Months__c, "48-Months")) , 0.02436,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 25000 && Total_Amount__c < 49999  &&  AND (ISPICKVAL( Months__c, "60-Months")) , 0.02014,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 50000 && Total_Amount__c < 99999 &&  AND (ISPICKVAL( Months__c, "24-Months")) , 0.04472,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 50000 && Total_Amount__c < 99999  &&  AND (ISPICKVAL( Months__c, "36-Months")) , 0.03069,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 50000 && Total_Amount__c < 99999  &&  AND (ISPICKVAL( Months__c, "48-Months")) , 0.02358,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 50000 && Total_Amount__c < 99999  &&  AND (ISPICKVAL( Months__c, "60-Months")) , 0.01923, NULL))))))))


REDUCED FORMULA...(giving me a ....Error: Syntax error)

IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Total_Amount__c > 50000 && Total_Amount__c < 99999  &&(CASE(1,IF(ISPICKVAL(Months__c,"24-Months")),0.04524,​​
IF(ISPICKVAL(Months__c, "36-Months")),​​0.03135, NULL))
Best Answer chosen by jcald
Sure@DreamSure@Dream
Hi jcald,

Try the following:
IF( Bank_Lender__r.Name  ==  "Mytestlender" &&  Amount__c > 149999 ,
CASE(Month__c,24,0.04521,36,0.03154,48,0.02474,60,0.02068,0),
0)

Thanks

All Answers

jcaldjcald
OK. I've reduced a little bit more.. any other tip or help is appreicated. Thanks

IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Amount__c > 149999 && Month__c=24,0.04521,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Amount__c > 149999 && Month__c=36,0.03154,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Amount__c > 149999 && Month__c=48,0.02474,
IF( Bank_Lender__r.Name  =  "Mytestlender" &&  Amount__c > 149999 && Month__c=60,0.02068,0
))))
Sure@DreamSure@Dream
Hi jcald,

Try the following:
IF( Bank_Lender__r.Name  ==  "Mytestlender" &&  Amount__c > 149999 ,
CASE(Month__c,24,0.04521,36,0.03154,48,0.02474,60,0.02068,0),
0)

Thanks
This was selected as the best answer
jcaldjcald
That worked! Thanks for this. After reducing the PICKLIST to a NUMBER field and then using a simple formula to give the Account name an abbreviated name for ex. "MyL1" and using your formula....made a HUGH world of difference in size.

Thanks again
jcaldjcald
I was wrong. I am over the 5000 limit  by 100. I also figured out changing the Account name to an Abbreviation compiled higher.  Anything else anyone can add to reduce compile size?


IF( Bank_Lender__r.RecordType.Name  == "XXXXXXXXXXXXXXX" && Amount__c > 9999 && Amount__c < 24999 ,
CASE(Month__c,24,0.04773,36,0.03267,48,0.02518,60,0.02072,0),


Even this...
&& Amount__c > 9999 && Amount__c < 24999
&& Amount__c > 25000 && Amount__c < 49999
&& Amount__c > 50000 && Amount__c < 99999 ,
&& Amount__c > 100000 && Amount__c < 250000 ,
jcaldjcald
Can any of you experts tell me if there is a way to reference an a Array/List into this formula..

CASE(Month__c,24,0.04773,36,0.03267,48,0.02518,60,0.02072,0)

for example... I would like to create an array with these numbers 0.04773, 0.03267, 0.02518, 0.02072

any help would be appreicated. Thanks