Skip to main content

Hello - 

 

I have a process that I cannot get to work. Essential a user selects a shipping price and thath price is populated into a custom field - [Opportunity].Shipping_Quote__c 

 

 

If that value is <= $15.00 I want the related opportunity line item for shipping to have a sales price of $15.00.  If it is > $15.00, I want teh related opportunity line item for shipping to have a sales price of the [Opportunity].Shipping_Quote__c  PLUS an upcharge cost.

 

I tried using a formula for just sales price = [Opportunity].Shipping_Quote__c +3.00 and that does not work.  I then created a new field called shipping upcharge [Opportunity].Shipping_Upcharge__c  and have tried a formula for sales price = [Opportunity].Shipping_Quote__c + [Opportunity].Shipping_Upcharge__c  and still not working.  The original value for shipping sales price does not change.

 

Open to suggestions as have tried a milion things and can't get this to work.

 

Process Builder formula to add two fields for a new sales price is not working
5 件の回答
  1. 2021年3月22日 16:26
    I led off the field type comment as issue seems to be with the sales price being just a currency field and not formua.  I created a new field for total price (formula type) and was able to set the formula for that field, then simply have the sales price = that new field.  Working now!
0/9000