+ Start a Discussion
Vadivel MuruganVadivel 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.
Dinesh PurohitDinesh Purohit
​IF(                                                                 // 1st -  IF OPEN
    OR(
        NOT(ISBLANK(Order_Value__c)),NOT(Order_Value__c=0)          // 1st - CONDITION
      ),
    (
     IF(                                                             // 2n - IF OPEN 
         Order_Value__c>Actual_Cost__c),                             // 2nd - CONDITION 
         ((Order_Value__c-Actual_Cost__c) / Order_Value__c),        // 2nd - IF TRUE
         ((Actual_Cost__c-Order_Value__c) / Order_Value__c))        // 2nd - IF FALSE 
        )                                                            // 2nd IF CLOSE (YOU FORGOT THIS)         
     ,0
  )                                                                   // 1st - IF CLOSE
Mrunali GaonkarMrunali Gaonkar
Hi Vadivel Murugan,
    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
   )