Issue in if condition for excluding?

[#1]

Hi,

maxgro‌ , swuehl‌

How do I write the if condition for excluding?

PCR = {111,1117,123,134}
Say if I want to include {111,1117} in my report

I would wite it as if(match(PCR,111,1117))

But how do I write the same if I want to exclude?
Can someone please tell me the opposite expression for match?

Thanks in advance.

Reagrds,
Sachin

[swuehl]

if( not match(PCR,111,1117), ThenBranch, ElseBranch)

[#3]

I tried but not match is not getting recognized as a function.

[sunny_talwar]

There needs to be a space between not and match:

the text for not and match turned blue mean they are getting recognized as functions.

HTH

Best,

Sunny

[ramoncova06]

if you are creating a calculated expression you could use concat or only combined with aggr

something like

aggr(concat({<PCR -={111,1117,123,134}>}PCR), PCR)

[swuehl]

Do you get an error telling so?

I believe it should work, but you can also use:

if( match(PCR,111,1117)=0, ThenBranch, ElseBranch)