biostatist
New Member
- Joined
- Jul 12, 2012
- Messages
- 14
ID | Test Resul | Dose Given | Dose Count |
87765 | Yes | 1 | |
87765 | 4 | ||
87765 | 20 | ||
87765 | Yes | 2 | |
96853 | Yes | 1 | |
96853 | Yes | 2 | |
96853 | 7 | ||
96853 | 10 | ||
96853 | Yes | 3 | |
435839 | 4 | ||
435839 | 7 | ||
435839 | Yes | 1 | |
435839 | Yes | 2 |
<tbody>
</tbody>
ID | Test Resul | Dose Given | Dose Count |
87765 | Yes | 1 | |
87765 | 4 | ||
87765 | 20 | ||
87765 | Yes | 2 | |
96853 | Yes | 1 | |
96853 | Yes | 2 | |
96853 | 7 | ||
96853 | 10 | ||
96853 | Yes | 3 | |
435839 | 4 | ||
435839 | 7 | ||
435839 | Yes | 1 | |
435839 | Yes | 2 |
What exactly do you mean by "count the actual doses" then? Are you saying the numbers you show in the "Dose Count" column are not the numbers you are trying to produce? If that is the case, then show us the actual numbers you want to see for the sample data you posted.Wait, sorry. I actually tried that one early on. It counts the number of instances that the particular ID and displays the count only when the "Dose" field says yes, but it does not count the actual doses.