Subtracting lists not working

I have the following formula for subtracting lists:

(Sheet1[Patient Name]-Target Table[Entry])

Following is the screenshot of Table Sheet1

Following is the screenshot of Table Target Table

I am using the above mentioned formula in a Column Type Enum List. But it is giving me the wrong output… The output it gives me is the following

Instead of subtracting, it is adding both the lists in the dropdown, items of Sheet1 are preselected.

I don’t know why it is happending

Judging by your last screenshot, I’m guessing you used the expression in Initial Value ? If that is the case, it is doing exactly what you told it to do. What do you want it to do?


Hi, thanks for replying. Yes I want it to show only those patient names from column “patient name” of table “Sheet1” which are not present in column “entry” of table “target table”. So, in above example, my enum list should only show (that also unchecked) the following patient names:
Bill Thomas
Tom cather

Initial Value is not the appropriate place to put your expression then.

1 Like

Thanks Marc, these helped a lot in clearing the problem. My basics were not clear.