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
Harris DHHarris DH 

Calculating the Percentage...

I am setting up workflows for certain fields for expiry of contracts. I want field A to trigger an email notification when it reaches 20% of field B. Can anyone help with a custom formula for this to happen? Thanks in advance!
RajaramRajaram
Harris,
 You can easily do this without the need to create a formula field.
 Create a workflow rule with the rule criteria set to "Every time the record is created or edited".
 Choose the rule criteria to be "formula evaluates to true" and use the following formula
 AND(
ISCHANGED( Field_A__c ),
(Field_A__c >= (0.20 * Field_B__c))
)

So, if Field B is 100 then this rule will fire only when Field A is changed and the value of Field A is >= 20.

Hope this helps..

Raja