Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this?
If((country = 'france', 'Europe') or (country = 'france', 'french'), 'other')
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
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
hi anil
can you also suggest the same for multiple countries.. ex: if country like france ,italy, spain then 'Europe' ,'french' else 'other'...
Here we go !!
If((Match(country, 'france', 'italy', 'spain'), 'Europe') or (Match(country, 'france', 'italy', 'spain'), 'french'), 'other')
do you want to have two rows for one Country in the table?
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?
hi anil,
there is some problem with the syntax.. iam not able to figure out. syntax ..below all the scripts gets black
hi tats, yes indeed