function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

How can I reduce the compiled size of a formula

Hi,
 
Can anyone help with this example formula please.  I have 10 formulas of this compiled size which then pushes me over the compiled size of 4000.
 
thanks,
Tracy.
 
IF( ISPICKVAL( {!Budget__c} ,"10: allocated and approved"),10,IF( ISPICKVAL( {!Budget__c},"8: allocated"),8,IF( ISPICKVAL( {!Budget__c},"5: planned"),5,IF( ISPICKVAL( {!Budget__c},"2: being bid for"),2,IF( ISPICKVAL( {!Budget__c},"-5: unidentified"),-5,null)))))
dcouchdcouch

Use the CASE function instead - it compiles smaller.


IF(CASE({!Budget__c},"10: allocated and approved",10, "8: allocated",8, “5: planned",5,"2: being bid for",2, “-5: unidentified",-5,null)



Dave