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
image

Following is the screenshot of Table Target Table
image

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?

2 Likes

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
Tom
Sue

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.

2 Likes