function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Michelle ArndtMichelle Arndt 

Syntax Error The formula expression is invalid: Syntax error. Found ')'

IF(OR([OpportunityLineItem].Product_Name__c="(D) Pick Up",[OpportunityLineItem].Product_Name__c ="(C) Delivery"),[OpportunityLineItem].UnitPrice*1.1,)

I get the syntax error. Found ')'     i am trying to multiple the price of either two products by 10%
Amit Chaudhary 8Amit Chaudhary 8
Please update like below

IF( OR([OpportunityLineItem].Product_Name__c="(D) Pick Up",[OpportunityLineItem].Product_Name__c ="(C) Delivery"),[OpportunityLineItem].UnitPrice*1.1 , 0  )

Please add else value in above formula i just added 0
Michelle ArndtMichelle Arndt
I have tried both.  I have the field that is going to be populated as a currency field.  This is the error receiving for both: 
The field "Fuel_Surcharge__c" isn't compatible with the Text element "formula_2_myRule_1_A1_Fuel_Surcharge_c". "formula_2_myRule_1_A1_Fuel_Surcharge_c" can't be a Text.