1 Reply Latest reply: Jul 5, 2014 7:57 AM by PAUL YEO RSS

    How to add 1 more condition to my expression

    PAUL YEO

      Hi All

       

       

      I have one expression is working fine , only have 1 condition :-

      if(match(Currency_P,'ID'),

       

       

      i like to make additional condition on :-

      if(match(Currency_P,'ID'),

       

       

      My Org Expression is below :-

       

       

      if(match(Currency_P,'SG'),

       

       

      money(

       

       

      (

       

       

      Ceil(

       

       

      AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU

       

       

      ,0.5)

       

       

      )

       

       

      ,CurrencyFormat_P),

       

       

      money(

       

       

      (

      Ceil(

       

       

      floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)

      ,0.5)

       

       

      )

       

       

      ,CurrencyFormat_P)

       

       

      )

       

       

      I modify the below :-

       

       

      if(match(Currency_P,'SG'),

       

       

      money(

       

       

      (

       

       

      Ceil(

       

       

      AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU

       

       

      ,0.5)

       

       

      ),CurrencyFormat_P),

       

       

       

       

      if(match(Currency_P,'ID'),

       

       

      money(

       

       

      (

      Ceil(

       

       

      floor(ceil(AFTER_DISCOUNT*X_RATE*TRANS_SUP/TDS_MU/MARKUP_SUB*RATE_ID*TAX_*DUTY_*TRANSPORT_SUB,.5), .1)

      ,0.5)

       

       

      )

      ),CurrencyFormat_P)

       

       

      )

       

       

      Above is not working.

       

       

      Hope some one can help me.

       

       

      Paul