Sign Up ›
  • Scott Key Tritech
  • NEWBIE
  • 0 Points
  • Member since 2014
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
3 replies

Formulas and Lookup Text Fields

I have a formula field that is using a Lookup(pricelist) field to do comparison. The other two fields I am using are number fields. When trying to save the formula I constantly get a "Compiled Formula is too big to execute".... Does the fact that this field comparison is a lookup field play that big of a role in the total formula size?
Here is the formula:
IF( Lookup(Price List) <> 'compare this', (NumField - NumField 2) * 0.14, 0.00)
3 replies

Formulas and Lookup Text Fields

I have a formula field that is using a Lookup(pricelist) field to do comparison. The other two fields I am using are number fields. When trying to save the formula I constantly get a "Compiled Formula is too big to execute".... Does the fact that this field comparison is a lookup field play that big of a role in the total formula size?
Here is the formula:
IF( Lookup(Price List) <> 'compare this', (NumField - NumField 2) * 0.14, 0.00)