I have a formula that seems to take in a regular workflow but want to use Process Builder and it's giving me a hard time.
Here is my formula:
([OpportunityLineItem].UnitPrice * [OpportunityLineItem].Opportunity.Contract_Term_Number__c / [OpportunityLineItem].Billing_Frequency_Number__c)
UnitPrice (aka Sales Price) is currency of course and the other two are just number fields updated from Picklist fields.
What am I doing wrong? Is there a trick to using these kinds of formulas in Process Builder?
답변 7개
Karin -
([OpportunityLineItem].UnitPrice * [OpportunityLineItem].Opportunity.Contract_Term_Number__c / [OpportunityLineItem].Billing_Frequency_Number__c)
As per your Old Formula which is written above. You are closing the small bracket at the end of the divisor. which is the Frequency number. You have three fields. So it should be like this,
(([OpportunityLineItem].UnitPrice) * ([OpportunityLineItem].Opportunity.Contract_Term_Number__c)) / ([OpportunityLineItem].Billing_Frequency_Number__c)
This should work. Let me know after you give it a try.
