cancel
Showing results for 
Search instead for 
Did you mean: 

Hide record with duplicate values in it sap

0 Kudos

Hi All,

I am trying to remove the following row with no success.

duplicate-row.png

I created a variable(Counter) that counts 2 for this record and tried to do the following formula:
If Counter = 2 and Status = "no" Then "Hide" Else "" ==> #MULTIVALUE

any suggstions?

Accepted Solutions (0)

Answers (2)

Answers (2)

amitrathi239
Active Contributor
0 Kudos

use the below steps.

Create a V Show/Hide variable=If(Count([ID];All) In ([ID])>1) And ([Status]="no") Then "Hide" Else "Show"

Filter on table where V Show/Hide variable equal to "Show"

0 Kudos

Hi Daniel ,

For webi, the first 2 rows are NOT duplicate because the values in the last column status are different (Yes and No). Webi looks for combinations in all columns in the query/report.

If you don't care about the information about the status , then remove the status field in the query, then you will be fix your issue.

Alternatively , if you just want to count unique IDs , you can create a variable which will take 1 or 0 and sum up the all the 1's only. It would look like this : If ([ID]=previous([ID]) then 1 else 0) . All the 1's would then give the number of unique IDs.

Hope this works for you.