conditional if statement?

[#1]

Hi all,

How to represent the multiple values for a filed in the if condition:

PLT  IN   ( 'ANMF','Partenon','UFSS'  )

COD2  IN  ( '1006'  )

if(COD2='1006'  AND PLT =( 'ANMF','Partenon','UFSS'  )

Iam using if condition as the conditional dimension for the bar chart. I tried with different options but not succeed.

Your help is greatly appreciated..

Regards

Siva

[Anonymous]

try this

=if((COD2='1006')  AND (match(PLT,'ANMF','Partenon','UFSS' )>0)

[Ralf-Narfeldt · Accepted solution]

if(COD2='1006'  AND match(PLT,  'ANMF','Partenon','UFSS' ))

[PrashantSangle]

Hi,

You can use match() or wildmatch() or mixMatch()

For  details go  and check it in Help menu.

Regards

[sasiparupudi1]

if((match(COD2,'1006')>0  AND match(PLT, 'ANMF','Partenon','UFSS')>0),'True','False')

[#6]

Try like this

if(COD2='1006'  AND (PLT = 'ANMF' OR PLT='Partenon'  OR PLT='UFSS'  ),..........)

[jonathandienst]

If this is for an aggregation function like Sum or Count, rather use set analysis:

Sum({<COD2 = {1006}, PLT = {'ANMF', 'Partenon', 'UFSS'}>} Value)

This will perform better than Sum(If())....

[#8]

Thanks for all your replies...

is this same for not equal sign? I mean for " not maching"

For ex:

ID= '01'

AND NOT(GRU='30390000' AND CON='A90' AND VAL IN ('IN1','IN2')))"

Regards

Siva