if statement

[raadwiptec]

is it possible to have if condition with 2 values for ex:

if country = france  then 'Europe' ,'french' else 'other'...

europe and french should be 2 diff values.

[Anil_Babu_Samineni]

May be this?

If((country = 'france', 'Europe') or (country = 'france', 'french'), 'other')

[prat1507]

Where are you planning to use this and why do you want it as two values and not a single value like Europe,French.

Regards
Pratyush

[raadwiptec]

because europe and french is refereeed as 2 different dimension in our database and the values diff little when you select europe and french seperately

[raadwiptec]

hi anil

can you also suggest the same for multiple countries.. ex: if country like france ,italy, spain then 'Europe' ,'french' else 'other'...

[Anil_Babu_Samineni]

Here we go !!

If((Match(country, 'france', 'italy', 'spain'), 'Europe') or (Match(country, 'france', 'italy', 'spain'), 'french'), 'other')

[t_chetirbok]

do you want to have two rows for one Country in the table?

[t_chetirbok]

something wrong

If(

     (     Match(country, 'france', 'italy', 'spain'), 'Europe')

or (     Match(country, 'france', 'italy', 'spain'), 'french')

, 'other')

did you want to put additional if before match?

[raadwiptec]

hi anil,

there is some problem with the syntax.. iam not able to figure out. syntax ..below all the scripts gets black

[raadwiptec]

hi tats, yes indeed