on 05-23-2012 6:28 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.