How to make my expression simplify ?

[paulyeo11]

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)

)

)

)))

))

))))))))

)

))

)

)

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

[paulyeo11]

my Qv Doc

[#3]

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

[its_anandrjs]

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.

[paulyeo11]

Hi Ram

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

Paul

Sent from Samsung Mobile

[paulyeo11]

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