Hi I am trying to compare a two Tables. If a company is listed in table 1 and the user is named “Dan” I would like to check the other table to see if ‘Dan’ also has an entry in that table for that company. With the goal being to be able to display the number of missing entries outside of the table.
I have tried using .in() and contains() and just can’t put my finger on the issue or if this is the right approach.
Comments.[Name 2].Filter(CurrentValue=[User Select]).Contains([Full table of companies].Name).Not().Count()
Here is my sample:
Any help is appreciated.