I have a Merch table and a table of Merch Locations, I am trying to create a slice showing a list of Merch from the locations table that do not exist in the Merch table.
Essentially, I am allowing scans of any merch item to the locations table, even if it does not exist in the Merch table. Now I need a list of those location merch items that don’t exist in the main merch table so I can follow up on adding those items to the merch table.
SOMETHING LIKE THIS SLICE FORMULA ON “Locations” table?
IF(([Merch ID]=“Merch”[Merch ID]), False, True)
This seems to return all items, I thought it would return non-matching…