Skip to main content
  Hello,  

 

    I have a formula field called Base Rate it is 

(UnitPrice / PricebookEntry.Product2.NumberOfRevenueInstallments)

We have revenue schedules on some products and with a revenue schedule the Sales Price (Unit Price) gets increased 12x , 24x or 36 times depending on 1,2,3 years of revenue.  So base rate is used to tell us what the original sales price was.  Is there a way with the Base Rate Formula field I can say if the Product has No revenue installments to put a 0 in the Base Rate field.  

 

 I'm using a Flow to clone opportunities and their Opportunity Line Items , using the Base Rate Value as the Sales price and its throwing a Flow Error when the product its cloning doesn't have a revenue Schedule because then the Base Rate is NULL and it can't be used as the Unit Price (Sales price) of the cloned Opportunity Line Item

 

 
3 个回答
  1. 2019年12月6日 20:10

    IF( ISBLANK(PricebookEntry.Product2.NumberOfRevenueInstallments), 0, (UnitPrice / PricebookEntry.Product2.NumberOfRevenueInstallments) )

     

     
0/9000