I have a customer that would like to see a list of all instances where one variable does not match another.

It seemed to me like this was not possible outside of Excel. I tried setting up a filter but you can only set variables on one side of the condition.

Is there something I am missing. Here is the scenario

There are 2 form processes, both contain a variable called ContractID. I created a report that combines both processes. I want to show all instances of Process 2 where Process 2 ContractID does not match any instances for Process 1 ContractID.

This will allow them to see everyone that participated in Process 1 who has not yet participated in Process 2.