Skip to Content
avatar image
Former Member

How to indicate and filter Duplicate Values on a report?


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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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]))

    Add comment
    10|10000 characters needed characters exceeded