Finding Duplicates within multiple Groups 1

[mainmandeano]

Group 1
Storecode

Group 2
OrderNumber

Group 3
ProductCode

Hi I'm hoping someone can help me.
My problem is that there are sometimes multiple orders for each store on the same date.
Duplicate products are sometimes ordered when this happens.
The report is planned to show duplicate usage of the product codes for each store.
The part I think it's falling short is getting the formula to work across two or more order numbers.

For example:
Store 23, order number 2, orders product x
then
Store 23, order number 3, orders product x

Maybe because of the different order number it does not pick up as a Duplicate value?


//Dupes placed in Group 3 Footer
if Count ({ProductCode}, {ProductCode}) > 1 then "Faults!!" else "Fine!"

 

[IanWaterman]

I would use a distinct cout RT and then compare with your count in store footer.

if Count ({ProductCode}, {Store}) <> {distinctproductcountstore} then "Faults!!" else "Fine!"

If that is not precise enough you will need to remove your order number group.

And place this in product code group footer.

if Count ({ProductCode}, {Productcode}) <> {distinctproductcountprod} then "Faults!!" else "Fine!"

Ian

 

[mainmandeano]

That's great Ian, I'm now getting alerted to Duplicates.

Many Thanks