Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
)
)))
))
))))))))
)
))
)
)
))))))))))))))))))))))))))))
my Qv Doc
you should use the first condition in a simple if and you can combine all other conditions using Pick and Match.
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.
Hi Ram
Can you give me some example . Do I know what you mean.
Paul
Sent from Samsung Mobile
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