1 Reply Latest reply: Jun 9, 2014 10:17 PM by PAUL YEO RSS

    How to combine 2 expression into 1 when TYPE=LOCAL PRODUCT is activate ?

    PAUL YEO

      Hi All

       

       

      Below is my Expression of Land Cost 1

       

       

      if(match(Currency_P,'SG'),

      money(

      (

      Ceil(

      LAND_COST_TDS_SGD

      ,0.5)

      )

      ,CurrencyFormat_P),

      money(

      (

      Ceil(

      FOB_SGD_SUB

      ,0.5)

      )

      ,CurrencyFormat_P)

      )

       

       

       

       

      Below is my Expression of Land Cost 2

       

       

       

       

      if(match(Currency_P,'SG'),

      money(

      (

      Ceil(

      LAND_COST_TDS_SGD

      ,0.5)

      )

      ,CurrencyFormat_P),

      money(

      (

      Ceil(

      FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS

      ,0.5)

      )

      ,CurrencyFormat_P)

      )

       

       

       

       

      Both are working fine . Now my task is to make 2 expression combine into 1 ( Land Cost 3 ) when user press TYPE = LOCAL PRODUCT.

       

       

      My imagine expression look some thing like below :-

       

       

      if(match(Currency_P,'SG'),

       

       

      money(

      (

      Ceil(

      LAND_COST_TDS_SGD

      ,0.5)

      )

      ,CurrencyFormat_P),

      )

       

       

      if(match(TYPE,'LOCAL PRODUCT'),

      money(

      (

      Ceil(

      FOB_SGD_SUB

      ,0.5)

      )

      ,CurrencyFormat_P),

      )

      money(

      (

      Ceil(

      FOB_SGD_SUB*TAX_*DUTY_*TRANSPORT_SUB_*RATE_P/LESS

      ,0.5)

      )

      ,CurrencyFormat_P)

       

       

       

       

      But it display nothing.