Comparing lists and identifying missing items
I am trying to figure out (after 2 days of frustration) how to identify when 2 lists are matching or different.
I have two lists in calculation fields (we can call the fields Completed and MasterList), with the values separated by carriage returns. I am trying to set up another field called NumberMissing to output on a subsummary report the number of items different between Completed and MasterList.
The lists are currently giving the primary keys of each item (in number form).
I would like NumberMissing to show "1" in this circumstance (I can pull in the useful name to show what exactly is missing once I get this figured out...).