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.
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.
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
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.
not sure how to solve this...
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