+ Start a Discussion

How To Auto Update The Sales Price Based On The Value Of Another Field

On the Product object I have 2 custom fields,  Floor_Price__c and Size__c. 
I want the standard Sales Price to be automatically calculated using the formula Floor_Price__c * Size__c.
So when I add a product to an Opportunity I want the stanard Sales Price to show the value based on the above formula. I have tried using WFR but I have been advised that the only way I can achieve what I am looking for is by using a Trigger. See below for reference.

User-added image

Hi mohdAnas,

How would this affect the Opportunity Amount field. Doesn't the Opportunity Amount field relate to the standard Sales Price field?