You need to sign in to do that
Don't have an account?
Vadivel Murugan
Formula Field
IF(OR(NOT(ISBLANK(Order_Value__c)),NOT(Order_Value__c=0)), (IF(Order_Value__c>Actual_Cost__c),((Order_Value__c-Actual_Cost__c) / Order_Value__c),((Actual_Cost__c-Order_Value__c) / Order_Value__c)),0)
Syntax error missing ')' Any one know replay me.
Syntax error missing ')' Any one know replay me.
Try the above formula.
IF(
OR(
NOT(ISBLANK(Order_Value__c)),NOT(Order_Value__c=0)
),
IF(
Order_Value__c>Actual_Cost__c,
((Order_Value__c-Actual_Cost__c) / Order_Value__c),
((Actual_Cost__c-Order_Value__c) / Order_Value__c)
),
0
)