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