Skip to main content
Topics#Data ManagementAlicia Castorina의 질문
Alicia Castorina (Act-On Software) 님이 #Data Management에 질문했습니다
2015년 2월 18일 오후 7:24

Need help to reduce the compile size of a formula field..

Hello!  I have a picklist field in the Account object that I need referenced within the related Opportunity object, but find that the compile size of my formula field is 207 characters too big. Specifically, I receive this error:

 

        "Formula(s) that reference this field are no longer valid:

 

         Compiled formula is too big to execute (5,207 characters).

 

         Maximum size is 5,000 characters (Related field: Formula)"

 

Any ideas on how to reduce the compile size of the following formula?

 

IF (OR  (ISPICKVAL ( Partner__r.Type, "RP1"), ISPICKVAL ( Partner__r.Type, "RTP")), "RP",

 

IF(ISPICKVAL(Partner__r.Type, "ARP"), "ARP", 

 

IF(ISPICKVAL(Partner__r.Type, "SCP"), "SCP", 

 

IF(ISPICKVAL(Partner__r.Type, "RP"), "RP", 

 

IF(ISPICKVAL(Partner__r.Type, "AAP"), "AAP",

 

IF(ISPICKVAL(Partner__r.Type, "RRP"), "RRP",

 

IF(ISPICKVAL(Account.Type, "RP"),"RPD",

 

IF(ISPICKVAL(Account.Type, "ARP"), "ARPD", 

 

IF(OR(ISPICKVAL(Account.Type, "RP1"), ISPICKVAL(Account.Type, "RTP")), "RP-D", 

 

IF(ISPICKVAL(Account.Type, "AAP"), "AAPD",

 

IF(ISPICKVAL(Account.Type, "RRP"),"RRPD",

 

IF(Partner__r.Current__c , "Customer" ,

 

IF(NOT (ISBLANK (Partner__c)), "Account", "None")

 

))))))))))))

 

(Where Current__C is a checkbox, Partner__c is a Lookup field.)   Relatively new to this end of Salesforce, but I can't help but think the repetitiveness of Partner__r.Type and Account.Type can be somehow reduced..  But then maybe not when working with a picklist?  

 

Any help appreciated, thank you!

 

- Alicia

 

 
답변 5개
  1. Alicia Castorina (Act-On Software)
    2015년 2월 18일 오후 8:28
    This may be a silly question, but can reducing the text quantity within the picklist field help?  So where "ARPD", change to "ARD", etc?  
답변을 작성하세요...
0/9000