+ Start a Discussion
AC1AC1 

Financial 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!

CaptainObviousCaptainObvious
Hope this helps:

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
)

 

ArchonArchon
From what I can tell you have 2 extra pairs of parenths.

I tried to separate them and if I'm seeing it right, the 2 extra pairs are at the beginning and at the end.  Try to take them out and see what happens.

((  <~~ extra
(( UnitPrice -  ( Del_Unit_Cost__c +  CUPS__c )+( Freight_Amount__c / Quantity  ))/ UnitPrice )
)),  <~~~extra
AC1AC1
Thanks so much!