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
It just me!It just me! 

Formula Total sum that will reevaluate when a percentage is deducted

Hello.  I have this formula that works perfectly fine. Final_Bonus__c

 

IF( ((Lead_dollar_null__c = 0)||(Lead_dollar_null__c = NULL)),(Lead_commision__c*(( Object1__r.edits__c * age__c) - ( Object1__r.cost__c * bonus__c ) )) 
, Lead_dollar_null__c )

But I added 3 fields that are Pecent fields.  The goal is when I add a number on any or all of the fields that it adjust the calculation of Final_Bonus__c.  However I'm getting an error that I cant add a formula.  Error is "Formula cannot use another formula field that directly or indirectly refers to itself."

 

Any ideas on how I can resolve the this problem?

Thanks in advance