Hi!
I have a problem with proper counting under the given condition.
I have a table “A” and a table “B”
Table A contains a list of item owners
Table B contains a list of items
In the table “A” I have a column in which I have to calculate the percentage of items inspected at the given owner.
In Table B, each item has an item owner ID assigned. That’s how I know which item belongs to which owner.
In order to calculate the percentage of items inspected by a given owner, I have to divide the number of items of the given owner with the status “Item has been checked” by the total number of items belonging to the given owner.
Thank you in advance for your help!
Solved! Go to Solution.
I found a solution!
Maybe this solution will be useful to someone else
(COUNT(SELECT(Table B[ID],AND([ID]=[_THISROW].[ID],[status]=“Item has been checked”)))) / (COUNT(SELECT(Table B[ID],[ID]=[_THISROW].[ID])))
I found a solution!
Maybe this solution will be useful to someone else
(COUNT(SELECT(Table B[ID],AND([ID]=[_THISROW].[ID],[status]=“Item has been checked”)))) / (COUNT(SELECT(Table B[ID],[ID]=[_THISROW].[ID])))
User | Count |
---|---|
45 | |
27 | |
27 | |
21 | |
13 |