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
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