Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
where homephone <> new_homephone
both are fields
Try like:
Homephone -={'new_homephone'}
or,
Homephone ={'*'} - {'new_homephone'}
Try like:
Homephone -={'new_homephone'}
or,
Homephone ={'*'} - {'new_homephone'}
i tried it....its not showing propere
it gives red underline below homephone(last)
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.
The red underline before the -= is a QV bug, but the expression is correct.
Assuming that EmployeeID is unique ID
Try this
=Count({<msjvcode={1001}, msemploymentstatus={'A'}, EmployeeID={"=homephone<>new_homephone"}>} homephone)
Try:
=count({<msjvcode={1000}, msemploymentstatus={'A'}, ~ homephone=new_homephone>} homephone)
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.