Looking for duplicate entries 1

[keving63]

I need to create a report that looks for duplicate pmt entries for a single claim. The report filters on last pmt date and only pulls claims with more than one payment entry. I've actually created something a while back that worked but the report got whacked and now I'm having trouble recreating this. I'm grouping on claim and I originally used the rank on the payment date and found a way to get the report to look at only payments attached to a particular claim. I've had absolutely no luck recreating this. Any help would be mucho appreciated.

 

[DoubleD]

What tells you it's a duplicate payment? Two of the same payment dates, two of the same payment amounts?

One way would be to create two reports:
The first report only contains ClaimID and a count of ClaimID records, this report has a summary filter where CountOfClaimID > 1.
The second report would give you the claim detail, filtered where ClaimID in (FirstReport).

I am what I am based on the decisions I have made.

DoubleD

 

[keving63]

I'm keying on the pmt amount to determine previous duplicate entries. I'll leave out the minimum count filter once the report is finished since the bigger issue will be limiting the report to just those claims with dupe payments regardless of payment entry count.

 

[DoubleD]

So make your count a distinct count of PaymentAmt.

The first report only contains ClaimID and a distinct count of payemtn amounts, this report has a summary filter where CountDistinctOfPaymentAmt > 1.
The second report would give you the claim detail, filtered where ClaimID in (FirstReport).

I am what I am based on the decisions I have made.

DoubleD