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

[#1]

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

[#2]

Hi All

Can some one advise me on this ?

Paul

[tresesco · Accepted solution]

PFA.

use expression like below for the variable v_Display_Exchange:

=Pick(Match(BRAND_P,'GE','BECKHOFF'),USA_SGD,EURO_SGD)

[#4]

Hi Paul,

  PFA..........Hope it will help you..........

Regards,

Nirmal.

[#5]

Hi Nirmal

Thank you very much for your sharing . you approach work fine. But the Tres solution is more neat :-

=Pick(Match(BRAND_P,'GE','BECKHOFF','HAKKO'),USA_SGD,EURO_SGD,USA_SGD)

Paul