Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thy {<Field-={'ábc', 'def', 'ghi'}>}
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.
May be this:
If(not Match(Field, 'abc', 'def', 'ghi'), DoSomething, DoSomethingElse)
Within Set analysis you might be able to do this:
{<Field -= {'abc', 'def', 'ghi'}>}
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
with set analysis you can try like this {}
IF(Not Match(Field,'Val1','Val2'),Field)