Complex Disposition Report showing Duplicates

Summary

Complex Disposition Report showing Duplicates

Content

Hello, 

I'm trying to identify ways to eliminate duplicates on an action based report where we pull by submission ID to identify if action is needed by recruiter to properly disposition candidate. The business has identified scenarios in which a recruiter should take action vs when they don't need to. In order to to make this as automated the as possible, we created logic/formulas to identify each scenario (Called Disp ID). I attached a sample report to show the types of duplicates we're getting. It's also equipped with the formulas we are using for various data pulls, and screenshot of our