AnsweredAssumed Answered

Comparing lists and identifying missing items

Question asked by StevenThimsen on Jun 29, 2015
Latest reply on Jul 1, 2015 by StevenThimsen

Title

Comparing lists and identifying missing items

Post

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).

 

Completed:

10

4

5

9

 

MasterList:

4

5

9

10

19

 

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...).

Outcomes