not equal in set analysis

[saumyashah90]

where homephone <> new_homephone

both are fields

[tresesco · Accepted solution]

Try like:

Homephone -={'new_homephone'}

or,

Homephone ={'*'} - {'new_homephone'}

[saumyashah90]

i tried it....its not showing propere

it gives red underline below homephone(last)

[Gysbert_Wassenaar]

That's just a bug in the syntax checker. The syntax is correct. If the expression doesn't return the correct result please post a sample document that demonstrates the problem.

[salto]

The red underline before the -= is a QV bug, but the expression is correct.

[CELAMBARASAN]

Assuming that EmployeeID is unique ID

Try this

=Count({<msjvcode={1001}, msemploymentstatus={'A'}, EmployeeID={"=homephone<>new_homephone"}>} homephone)

[#7]

Try:

=count({<msjvcode={1000}, msemploymentstatus={'A'}, ~ homephone=new_homephone>} homephone)

[christian77]

Hi:

Let's be careful. It's not the same - = {'A'} means A is excluded, as

= {'*'} - {'A'} Means A is excluded but everything else is included even when is not in the actual selection.

I guess what you are looking for is = {'<>A'} that means A is excluded but still the expression obeys to the actual selection.

luck.