Skip to Content
0
Former Member
Sep 21, 2017 at 10:43 AM

How to indicate and filter Duplicate Values on a report?

46 Views

Hi

I have a BO Report (Webi or Rich Client). Objects are Supplier, Order Number, Cost Center and Total value. I would like to find duplicate values for a Supplier. The order numbers differ, but the values are the same. The value recur sometimes 4 or 5 times. I suspect that it might be duplicate orders and would like to highlight/indicate where these occur. Therefor I would like to filter on those indication. I did do a Break on the values, but then I get 730 pages of which only 7 pages are actually repetitions. Is there a way to write a IF statement or do an conditional rule or anything at all.

I will appreciate any feedback. Please send to dutoit.wesselj@gmail.com

Regards

Wessel