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
AC1AC1 

Formula Error

    Can someone help?  I have created the following formula and I keep getting Syntax errors.  Missing  ")" 


IF(
      ISPICKVAL(FOB_Point__c ,"Delivered"),
      (((( UnitPrice -  ( Del_Unit_Cost__c +  CUPS__c )+( Freight_Amount__c / Quantity  ))/ UnitPrice ))),
      (UnitPrice - (Del_Unit_Cost__c + CUPS__c))/UnitPrice


Thank you!
Execute EZSAASExecute EZSAAS
I think you have unnessary parenthesis., but you are definitely missing the corresponding closing parenthesis ')' for the opening of IF ( - so try this
Code:
IF(
      ISPICKVAL(FOB_Point__c ,"Delivered"),
      (((( UnitPrice -  ( Del_Unit_Cost__c +  CUPS__c )+( Freight_Amount__c / Quantity  ))/ UnitPrice ))),
      (UnitPrice - (Del_Unit_Cost__c + CUPS__c))/UnitPrice
)