5 Replies Latest reply: Jul 8, 2014 1:57 AM by PAUL YEO RSS

    How to make my expression simplify ?

    PAUL YEO

      Hi All

       

      I have a expression which is working fine , and look for solution to simpliy it. in case some one have good idea pls share.

       

       

       

       

       

      if

      (

      match(Currency_P,'SG') and (match (BRAND_P,'IBH')),

       

       

      (AFTER_DISCOUNT*RATE_IBH*T_IBH/1),

       

       

      if

      (

      match(Currency_P,'SG') and (match (BRAND_P,'BECKHOFF')),

       

       

      (AFTER_DISCOUNT*RATE_BK*T_BK/1),

       

       

      if

      (

      match(Currency_P,'SG') and (match (BRAND_P,'PHOENIX')),

       

       

      (AFTER_DISCOUNT*RATE_PH*T_PH/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'GE')),

       

       

      (AFTER_DISCOUNT*RATE_GE*T_GE/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'PHOENIX')),

       

       

      (AFTER_DISCOUNT*RATE_PH*T_PH/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'TOP')),

       

       

      (AFTER_DISCOUNT*RATE_TOP*T_TOP/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'MITSUBISHI')),

       

       

      (AFTER_DISCOUNT*RATE_MI*T_MI/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'REDLION')),

       

       

      (AFTER_DISCOUNT*RATE_RED*T_RED/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'SECOMEA')),

       

       

      (AFTER_DISCOUNT*RATE_SEC*T_SEC/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'KEB')),

       

       

      (AFTER_DISCOUNT*RATE_KEB*T_KEB/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'KINCO')),

       

       

      (AFTER_DISCOUNT*RATE_KI*T_KI/1),

       

       

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'HMS')),

       

       

      (AFTER_DISCOUNT*RATE_HMS*T_HMS/1),

       

       

      if(match(Currency_P,'SG') and (match (BRAND_P,'HAKKO')),

       

       

      (AFTER_DISCOUNT*RATE_HA*T_HA/1),

       

       

       

       

      if

      (

      match(Currency_P,'MY') and (match (BRAND_P,'IBH')),

       

       

      (AFTER_DISCOUNT*RATE_IBH*RATE_MY*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'GE')),

       

       

      (AFTER_DISCOUNT*RATE_GE*RATE_MY*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'PHOENIX')),

       

       

      (AFTER_DISCOUNT*RATE_PH*RATE_MY*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'BECKHOFF')),

       

       

      (AFTER_DISCOUNT*RATE_BK*RATE_MY*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'KEB')),

       

       

      (AFTER_DISCOUNT*RATE_KEB*RATE_MY*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'HMS')),

       

       

      (AFTER_DISCOUNT*RATE_HMS*RATE_MY*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'MITSUBISHI')),

       

       

      (AFTER_DISCOUNT*RATE_MI*RATE_MY*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'REDLION')),

       

       

      (AFTER_DISCOUNT*RATE_RED*RATE_MY*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'SECOMEA')),

       

       

      (AFTER_DISCOUNT*RATE_SEC*RATE_MY*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'HAKKO')),

       

       

      (AFTER_DISCOUNT*RATE_HA*RATE_MY*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

      if(match(Currency_P,'MY') and (match (BRAND_P,'TOP')),

       

       

      (AFTER_DISCOUNT*RATE_TOP*RATE_MY*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_MY),

       

       

       

       

      if

      (

      match(Currency_P,'THAI') and (match (BRAND_P,'IBH')),

       

       

      (AFTER_DISCOUNT*RATE_IBH*RATE_THAI*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'GE')),

       

       

      (AFTER_DISCOUNT*RATE_GE*RATE_THAI*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'PHOENIX')),

       

       

      (AFTER_DISCOUNT*RATE_PH*RATE_THAI*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'BECKHOFF')),

       

       

      (AFTER_DISCOUNT*RATE_BK*RATE_THAI*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'TOP')),

       

       

      (AFTER_DISCOUNT*RATE_TOP*RATE_THAI*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'KINCO')),

       

       

      (AFTER_DISCOUNT*RATE_KI*RATE_THAI*T_KI*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'MITSUBISHI')),

       

       

      (AFTER_DISCOUNT*RATE_MI*RATE_THAI*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'SECOMEA')),

       

       

      (AFTER_DISCOUNT*RATE_SEC*RATE_THAI*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'KEB')),

       

       

      (AFTER_DISCOUNT*RATE_KEB*RATE_THAI*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'HMS')),

       

       

      (AFTER_DISCOUNT*RATE_HMS*RATE_THAI*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'HAKKO')),

       

       

      (AFTER_DISCOUNT*RATE_HA*RATE_THAI*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

      if(match(Currency_P,'THAI') and (match (BRAND_P,'REDLION')),

       

       

      (AFTER_DISCOUNT*RATE_RED*RATE_THAI*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_THAI),

       

       

       

       

       

       

       

       

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'IBH')),

       

       

      (AFTER_DISCOUNT*RATE_IBH*RATE_ID*T_IBH*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'BECKHOFF')),

       

       

      (AFTER_DISCOUNT*RATE_BK*RATE_ID*T_BK*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'PHOENIX')),

       

       

      (AFTER_DISCOUNT*RATE_PH*RATE_ID*T_PH*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'HAKKO')),

       

       

      (AFTER_DISCOUNT*RATE_HA*RATE_ID*T_HA*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'MITSUBISHI')),

       

       

      (AFTER_DISCOUNT*RATE_MI*RATE_ID*T_MI*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'HMS')),

       

       

      (AFTER_DISCOUNT*RATE_HMS*RATE_ID*T_HMS*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'KEB')),

       

       

      (AFTER_DISCOUNT*RATE_KEB*RATE_ID*T_KEB*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'SECOMEA')),

       

       

      (AFTER_DISCOUNT*RATE_SEC*RATE_ID*T_SEC*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'KINCO')),

       

       

      (AFTER_DISCOUNT*RATE_KI*RATE_ID*T_KI*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'TOP')),

       

       

      (AFTER_DISCOUNT*RATE_TOP*RATE_ID*T_TOP*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'REDLION')),

       

       

      (AFTER_DISCOUNT*RATE_RED*RATE_ID*T_RED*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID),

       

       

      if(match(Currency_P,'INDO') and (match (BRAND_P,'GE')),

       

       

      (AFTER_DISCOUNT*RATE_GE*RATE_ID*T_GE*TAX_*DUTY_*TRANSPORT_SUB_/MU_ID)

      )

      )

      )))

      ))

      ))))))))

      )

      ))

      )

      )

      ))))))))))))))))))))))))))))