Print this page

How can a formula field be overridden?

Knowledge Article Number 000220799
Description Is it possible to overridden a formula field based on certain condition?
Resolution Formula are read-only. There is no way to directly overridden them. However there is a workaround to overridden formula field.

Use Case - A sales organization can be interested in calculating commission amount but allow overridden the same on certain case.

In this article we are considering a field called Commission_Amount__c. So this field will calculate the commission amount as 5% of opportunity amount. So the formula field will be having the formula as Opportunity.Amount * .05
  1. Create a new field, called Commission Field Override. Make it a currency field
  2. Create a formula field called Commission Amount with the following formula
BLANKVALUE(Commission_Field_Override__c,Opportunity.Amount*.05)

If the Commission Field overridden is populated, it will just display that value directly. Otherwise the value will be derived from formula Opportunity.Amount*.05




promote demote