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
RRESRRES 

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(ISNULL(Product__r.Amazon_Price__c),Product__r.MSRP__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.