How to compare data in a table?

[#1]

Hi,

I have one table that holds data of invoices. I want to test if I have duplicate invoices. A duplicate invoice is an invoice with the same invoice number, customer name, invoice date and invoice amount.

Do you have any idea how I could build up this test an generate a table with these duplicate invoices?

Thanks in advance!

Kind regards,

Jens

[swuehl]

Maybe just create a straight table with dimensions invoice number, customer name, invoice date and invoice amount and one expression:

= if(count([invoice date]) >1,1,0)

This should flag and filter (if supress zero values is enabled in presentation tab) your duplicates.

Hope this helps,

Stefan

[#3]

Thanks a lot this indeed solved my problem!

Kind regards,

Jens