currently I am using the following set analysis to count the number of unique occurrences of a party_id in a date range. I'm needing to count the number of unique id's that occur across a combination
This works (mostly), however there are instances where the sum is zero'd out because there are positive and negative values that cancel each other out. Does anyone have any suggestions using set analysis to count distinct ID's in a date range, where occurrences in any of the three fields -= 0?