+ Start a Discussion

Strange Formula Field Issue

I have a strange formula field issue. I create two formula fields:



IF(Product__r.MSRP__c > Product__r.Amazon_Price__c , Product__r.Amazon_Price__c *0.99,
IF(Product__r.Amazon_Price__c > Product__r.MSRP__c, Product__r.MSRP__c*0.99,
IF(ISNULL(Product__r.MSRP__c ),Product__r.Amazon_Price__c*0.99,
IF(Product__r.Amazon_Price__c = Product__r.MSRP__c,Product__r.MSRP__c*0.99,NULL )))))

Product__r.MSRP__c and Product__r.Amazon_Price__c are both currency fields.


The other formula is:



ROUND((Initial_OpenSky_Price__c - Drop_Ship_Fee__c), 0.01)


The second formula compiles fine however when I change the ROUND to CEILING I get the following error:


Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (7,633 characters). Maximum size is 5,000 characters


I'm not quite sure what the issue ishere. If any one has any ideas please let me know. Thanks, Rich.