The purpose of the Same-Same-Different test (SSD) is to identify abnormal duplications as potential indicators of errors or fraud.
Any tips on how to apply this methodology in in Report Studio? I'd like to use [Invoice Number] and [Paid Amount] as the 'Same' factors, and [Vendor Number] as the 'Different' factor.
Consider the following data set:
Vendor Number Paid Amount Invoice Number
4 95.5 JAN002
4 95.5 JAN003
5 100.01 JAN004
4 100.01 FEB005
5 100.01 FEB005
I would like to return the following results:
Vendor Number Paid Amount Invoice Number
4 100.01 FEB005
5 100.01 FEB005
Any suggestions?
Thanks in advance!
Bump!!
Clarified question for ease - bump!
FYI, solved this problem doing the following:
1. Created a data item, [NEWDATAITEM], with the following expression: count(distinct [Vendor Number] for [Invoice Number], [Paid Amount])
2. Created a detail filter with the following expression: [NEWDATAITEM] > 1
This kicked out the instances where the invoice number and paid amounts were the same, but had distinct vendor numbers between the transactions.
Hopefully this helps someone in the future. :)