Skip to main content
Topics#Data ManagementFrage von Karin McWilliams
Karin McWilliams fragte in #Data Management
26. März 2018, 21:30

Formula Error in Process Builder - The formula expression is invalid: Syntax error. Missing '='

Hi All - I see others struggling with this but haven't found the answer based on what I'm using for my formula.

 

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 Antworten
  1. Rupesh Balaji Nethaji Babu (Salesforce)
    26. März 2018, 23:31
    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.
Antwort schreiben...
0/9000