Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Chris HeathChris Heath 

Length of compiled characters for formula field inside formula?

I have a question about what causes referencing a formula field inside a formula to add so many characters to the compiled character count.

I have a formula(text) field (call it Formula__c) that is just 
TEXT(Parent__r.Picklist_Field__c)

When I reference this in a new formula field 
IF(Formula__c == "Text Value", TRUE_STUFF, FALSE_STUFF)
It seems to add around 250 more characters to the compiled character count than if I were to just do 
IF(ISPICKVAL(Parent__r.Picklist_Field__c, "Text Value"), TRUE_STUFF, FALSE_STUFF)
Where do all of the extra characters come from?
 
Best Answer chosen by Chris Heath
Veenesh VikramVeenesh Vikram
Hi Chris,

This is because when we refer a formula field inside another formula field, the character count of the referred fprmula is also added to the Character count of the referring formula field.

Regards
Veenesh