Skip to Content
0

How to indicate and filter Duplicate Values on a report?

Sep 21, 2017 at 11:15 AM

29

avatar image
Former Member

bo.jpgHi

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

bo.jpg (281.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Sep 21, 2017 at 01:25 PM
0

try this for to find duplicate values.Filter on variable where not equal to 1

=runningcount([Total Spend];([Total Spend];[Supplier]))

Share
10 |10000 characters needed characters left characters exceeded