Book Image

Salesforce CRM - The Definitive Admin Handbook

By : Paul Goodey GP, Paul Goodey
Book Image

Salesforce CRM - The Definitive Admin Handbook

By: Paul Goodey GP, Paul Goodey

Overview of this book

Table of Contents (18 chapters)
Salesforce CRM – The Definitive Admin Handbook Third Edition
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Building formula text and compiled character size limits


There is a text character and byte size limit of 3,900 characters and a limit of 5,000 characters for the compiled characters for formulas.

When this limit is reached, you will be unable to save the formula field and will be presented with the following error:

Compiled formula is too big to execute (7,085 characters). Maximum size is 5,000 characters.

It is common to encounter these limits when building complicated formula field calculations, particularly when building formulas that reference other formula fields. While there is no way to increase this limit, there are some methods to help avoid and work around these limitations; they are listed as follows:

  • Use the CASE function for branch conditions

  • Use algebra

For formulas that use multiple branch conditions to derive the values, as in the preceding example formula, check whether the market is US and the state is California, Nevada, or Utah. You can replace the nested IF statements and...