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
shravanshravan 

Formula Field exceeding 5000 characters

Hi All,

In formula field exceeding 5000 characters, here I used Formula_Field_Value__c in 3 times, is it possible to reduce 2 times with same result.

IF( Formula_Field_Value__c <=0, "",
IF( Formula_Field_Value <=1.6, "Low",
IF(Formula_Field_Value__c >= 2.2,"High","Medium")
))

 

Informaion:

And the solution should be in formula field becuase for old records also it should update the field value.

if it is workflow old value are not updating so in this case it should be in formula field.

 

Regards,

Shravan Boddula

Madhan Raja MMadhan Raja M

Hi Shravan,

 

Use CASE instead of IF function in your formula. The Compile size for CASE is very less when compared with IF function.

 

Case help link: https://ap1.salesforce.com/help/doc/user_ed.jsp?section=Customizing&target=customize_functions.htm%2...

 

If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.

 

Madhan Raja M
Noam.dganiNoam.dgani

1. Your problem is probably in the formula_field_value__c - not to much her trim here. 

Can you post that?

 

additionally, setting the value for existing records is the issue, than why not use the data loader for a 1 time data fix?