Skip to Content

How to indicate and filter Duplicate Values on a report?

Sep 21, 2017 at 11:15 AM


avatar image


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



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

1 Answer

Sep 21, 2017 at 01:25 PM

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

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

10 |10000 characters needed characters left characters exceeded