how to show condn with not equals to ?

[nikhilgarg]

Hey,

I have a field whose values should not be equal to abc, def, ghi.

I tried:

Field<>{'ábc', 'def', 'ghi'} ;

But it is giving error.

Is there any other way ?

thanks

[#2]

Thy {<Field-={'ábc', 'def', 'ghi'}>}

[nigel987]

Hi Nikhil,

try the following:

Field={"<>Value"}

Example: count({$<ID={"<>0"}>} user)

this counts all users which ID is not zero.

I hope this helps.

[sunny_talwar]

May be this:

If(not Match(Field, 'abc', 'def', 'ghi'), DoSomething, DoSomethingElse)

[sunny_talwar]

Within Set analysis you might be able to do this:

{<Field -= {'abc', 'def', 'ghi'}>}

[sasiparupudi1]

if using in set analysis

{<Field-={'abc', 'def', 'ghi'}>}

if you want to use it in an if condition

if (Field<>'abc' and Field<>'def' and Field<>'ghi',dosomething, dosomethingelse)

HTH

Sasi

[#7]

with set analysis you can try like this {}

[Anonymous]

IF(Not Match(Field,'Val1','Val2'),Field)