I see a difference in the Expression Assistant and the App.
I have a simple Text Column that is scanable.
In Valid If I say
The Expression Assistant gives me the result with duplicates.
But the App removes duplicates.
In my App I need to have the duplicates.
(In real I’m saying: give me all Item Numbers and substract those already added. But since some Items can be added twice, I need to have duplicates.)