You need to sign in to do that

Don't have an account?

jcald

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))

# 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))

Sure@DreamHi 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

jcaldOK. 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@DreamHi 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

jcaldThat 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

jcaldI 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 ,

jcaldCan 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