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 LIST(1,2,3)+LIST(1,2,3)
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.)
I know that subtracting one list from another has the side-effect of removing duplicates, as @Steve mentioned here.
But does combining lists also has this side-effect?
User | Count |
---|---|
43 | |
30 | |
25 | |
23 | |
13 |