cancel
Showing results for 
Search instead for 
Did you mean: 

Display Duplicate records based on Keyfigure value in WebI report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank you, Ranjani. The function 'Previous ' works.

Best Regards,

Srilakshmi B

Former Member
0 Kudos

Hi,

There is a problem with using just the Previous function.

The records are identified as DUplicate only if the Previous value and the Current Value of the Dimensions/Keyfigures are same.

In my requirement written earlier, if the duplicate records are not one after another, then the Previous function does not work.

For eg:

In the above picture,  Record with SAP Document Number 1002 is a duplicate. And the Row 8 is a duplicate and hence in the report output, 1002 in Row 8 needs to be highlighted. But using function 'Previous', this does not happen. SInce 1002(Row 😎 is compared with the Previous value which is 1004 (Row 7).

Please suggest how to compare 1002 with all the previous values of SAP Document Number and higlight 1002 as duplicate. I tried using Between(Fisrt value;Previous Vlaue) funtion. But this is not working as expected since SAP Document Number is a Dimension and not a Keyfigure.

Please let me know how to go about this.,

Thanks and Regards,

Srilakshmi B

former_member188911
Active Contributor
0 Kudos

What happens if you convert the Dimension into a Measure?  The function ToNumber() could do the job

Thanks

Former Member
0 Kudos

Hi Simone,

Thanks for the suggestion.I tried using the ToNumber function. It still does not work.

The duplicates are not identified properly.

Are thr other ways of doing this? Please suggest.

Thanks and Regards,


Srilakshmi B

former_member188911
Active Contributor
0 Kudos

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!

Answers (1)

Answers (1)

Former Member
0 Kudos

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