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
Jorge BestardJorge Bestard 

What's wrong with this formula?

User-added image
Mahesh DMahesh D
Hi Jorge,

Its an issue with the length of the formula.

How Large Can A Formula Be?
Formula fields start off as a semi-human-readable formula with a maximum of 3900 characters. The formula is then converted into machine-readable code in a process called compiling. The result cannot exceed 5000 characters. We do not know the exact process Salesforce.com uses, but other systems consider lexical analysis, preprocessing, parsing, semantic analysis, code generation, and code optimization. Therefore, it is very difficult to predict the resulting size and the only practical way is to use the “Check Syntax” button and have the system calculate it.

Please look into the below links:

http://www.crmverse.com/four-solutions-to-salesforce-com-too-big-to-execute-formula-error/

Similar posts on the same topic:

http://salesforce.stackexchange.com/questions/41643/formula-field-is-too-big-to-execute-5-480-characters

http://salesforce.stackexchange.com/questions/87741/compiled-formula-too-big-max-is-5-000

http://salesforce.stackexchange.com/questions/72751/compiled-formula-is-too-big-to-execute-reduce-formula-size

https://developer.salesforce.com/forums/?id=906F00000008wd2IAA

https://developer.salesforce.com/forums/?id=906F00000008wmwIAA

https://developer.salesforce.com/forums/?id=906F00000008xjIIAQ

https://developer.salesforce.com/forums/?id=906F00000008xPIIAY

Idea posted on this:

https://success.salesforce.com/ideaView?id=08730000000klfHAAQ

Please do let me know if it helps you.

Regards,
Mahesh
StephenKennyStephenKenny
It looks like one of the fields you are using is a formula field too, either Contract_Length__c or MRR_DV__c. The error message states that a formual field can be a maximum of 5000 characters which means that the characters from formula field you are referencing + the characters from the formual field you are creating cannot exceed 5000.

Lets say that the Contract_Length__c is a formula and is 1000 characters in total. Because you have referenced it 3 times in this formula, that adds up to 3000 already.

Hope that's all clear and helps.
Jorge BestardJorge Bestard
Strange, contract length is just months... so double digits and MRR is just a monetary value $500.45 etc.

not sure how to solve this...
Mahesh DMahesh D
Hi Jorge,

Please look into these solutions, it may be workaround for your issue.

http://www.crmverse.com/four-solutions-to-salesforce-com-too-big-to-execute-formula-error/

Regards,
Mahesh