You need to sign in to do that
Don't have an account?
AC1
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!
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!
Code:
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