on 07-11-2019 1:34 PM
Hi All,
I am trying to remove the following row with no success.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
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.