You need to sign in to do that
Don't have an account?
Scott Key Tritech
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)
Here is the formula:
IF( Lookup(Price List) <> 'compare this', (NumField - NumField 2) * 0.14, 0.00)
How are the two objects connected? As a way to trouble shoot this, you could make one formula that pulls in the value to your current object via a lookup, if you can do this you should be able to do your formula.