4 Replies Latest reply: Sep 16, 2013 3:28 AM by Paul Yeo RSS

    Input box 2 line how to reduce to 1 line using expression ?

      Hi All

       

       

      I have input Box , now need to use 2 line to display the exchange rate , i hope it can just using 1 line.

       

       

      if user select BRAND_P=GE or HAKKO , display USA_SGD

      if user select BRAND_P=BECKHOFF , display EURO_SGD

       

       

       

       

      My exchange rate field is define by :-

       

       

      lET EURO_SGD = 1.8;

       

       

      lET USA_SGD = 1.4;

       

       

      I follow example given by SOK :-

       

       

      =

       

       

      If(Match(BRAND_P,'GE'),TRANSPORT_GE,

       

       

      If(Match(BRAND_P,'BECKHOFF'),TRANSPORT_BK,

       

       

      TRANSPORT_HAKKO))

       

       

      Below is the expression i imagine , it cannot work :-

       

       

      If(Match(BRAND_P,'GE'),USA_SGD,

       

       

      If(Match(BRAND_P,'BECKHOFF'),EURO_SGD,

       

       

      USA_SGD))

       

       

      Hope some one can help me.

       

       

      Paul