New Bug Encountered: Valid If removes Duplicates

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.
2X_c_c261a5a2ff10ba3dbfc7c35cf668394ca0fa6c2b.png
But the App removes duplicates.
2X_0_0a3381b301f901ef7e32e36b180abbcd0a969bcf.png

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?

0 7 335
7 REPLIES 7
Top Labels in this Space