When I include ~ sign in front of INVENTORY to explicitly exclude the values of inventory kpg , td from the current selection.Even when i make selection only on kpg or td either, its returning values.
When I use Count({$-1<INVENTORY={'kpg','tdj'}>}Device) , its working fine. Would anyone else also find this problem, when use ~ , getting incorrect values?
I never really use the ~, but I tried it the other day and was getting odd results. I'm not sure what exactly it does. You can use the - exclusion in your expression and that seems to work. Try this:
I never really use the ~, but I tried it the other day and was getting odd results. I'm not sure what exactly it does. You can use the - exclusion in your expression and that seems to work. Try this:
Looking at the help text, it appears that ~ is only used for forced exclusion for fields in and-mode:
"Finally, for fields in and-mode, there is also the possibility of forced exclusion. If you want to force exclusion of specific field values, you will need to use "~" in front of the field name."
Look for and-mode in the help text index for more information. But basically, under some very specific conditions, you can set up a list box for and-mode on a field. In this mode, a forced exclusion (which the ~ is duplicating) is an AND NOT. So you could make several selections in the list box, and you'd only see records matching ALL of those selections. But with set analysis, you could add to it that the record must NOT match some other value.
I've never used it in a real application, but I might as well try to set up an example based on my understanding.
OK, see attached. It demonstrates and mode and the difference between forced exclusion (~) and regular exclusion (-) when using set analysis.
I don't know what forced exclusion does when NOT in and mode. It doesn't seem like it was intended to be used that way. I'll need to experiment further.
