Skip to Content
author's profile photo Former Member
Former Member

Display Duplicate records based on Keyfigure value in WebI report

Hi all,

I have the following requirement on the WebI Report:

The report has Characteristics: Vendor, Doc number, Line item and Key figure: Invoice Value.

There can be multiple Document numbers against a Vendor and a Doc number. Now, I need to identify the document numbers same invoice values.

I need to either place an alert/rule highlighting the duplicate Doc numbers( Doc numbers ith same Invoice Value) or pick those Doc numbers and list them separately in the report.

In the above screenshot, since the SAP Document number (1st Column) has duplicate values with same Invoice values (1st and 2nd rows), the document number 1000 needs to be highlighted or separately listed (In this case, both 1st and 2nd rows need to be highlighted).

I tried using few functions using RowIndex, LineNumber but could not achieve the result.

Could you please help me with suggesing how do I proceed with this.

Thanks and Regards,

Srilakshmi B

Sample.JPG (18.1 kB)
Sample.JPG (14.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 23, 2012 at 06:07 AM

    Hi Srilakshmi

    Have u tried pervious function?

    create a variable with this formula,

    =if((vendor) = previous(vendor)) and (doc number = previous(doc number)) and (line item=previous(line item)) and (key figure = previous(key figure))) then "duplicate" else "Not"

    With the above,the duplicate line items will be shown as "Duplicate" on the newly created variable.Then,u can apply an alert on this variable like--- if the value is "duplicate" <action to be performed>

    Hope I've understood your requirement !!!

    Regards

    RR

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello, you say:

      > if the duplicate records are not one after another, then the Previous function does not work.

      Please notice that the Previous function works only with the previous row in a table and doesn't apply to the cross-tabs

      At the moment if you need anytrhing else you have to create a table where the values you need are in the order that allows the formula to perform the calculations, however you can submit an idea for an advanced type of Previous() function that takes as a reference another value https://ideas.sap.com

      Thanks!

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 12:48 PM

    Hi Srilakshmi

    If it is required to compare the duplicates of a fixed value(say 1002 in this case),then you can add a cloumn and create a formula like,

    =1 Where ([SAP Document Number] = "1002")

    In this case,all records having SAP Document Number will have a 1 in this column.Then you can apply an alerter in this column to highlight the same

    Regards

    RR

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.