5 Replies Latest reply: Jul 8, 2014 1:57 AM by Yeo Poh sai

# How to make my expression simplify ?

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)

)

)

)))

))

))))))))

)

))

)

)

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

• ###### Re: How to make my expression simplify ?

my Qv Doc

• ###### Re: How to make my expression simplify ?

you should use the first condition in a simple if and you can combine all other conditions using Pick and Match.

• ###### Re: How to make my expression simplify ?

Hi Ram

Can you give me some example . Do I know what you mean.

Paul

Sent from Samsung Mobile

• ###### Re: How to make my expression simplify ?

You can apply this condition in the Backend means in script level and then use the fields in the charts is the best way because if you use if condition with nested if condition will effect the performance of yours chart it will get slow. For doing this you have to use put this condition in script levels.

• ###### Re: How to make my expression simplify ?

Hi Ana

I unable to do it at script level . Because user need to Chamge the exchange rate and mark up.

Paul

Sent from Samsung Mobile