4 Replies Latest reply: Jul 5, 2014 9:37 PM by PAUL YEO RSS

    match command how to add 2nd condition ?

    PAUL YEO

      Hi All

       

       

      I have created the expression below which match 1 CONDITION IF COUNTRY = SG ( WORKING FINE ):-

       

       

      if(match(Currency_P,'SG'),

      money(

      (AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS),

      CurrencyFormat_P)

      )

       

       

      Now I need to add one more condition :-

       

       

      BRAND_P=GE

       

       

      I try :-

       

       

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

      money(

      (AFTER_DISCOUNT*RATE_EU*TRANS_SUP/MU_TDS),

      CurrencyFormat_P)

      )

       

       

      it does not work , hope some one can help me.

       

       

      Paul