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개
IF( ISBLANK(PricebookEntry.Product2.NumberOfRevenueInstallments), 0, (UnitPrice / PricebookEntry.Product2.NumberOfRevenueInstallments) )
