I need to create a report on the number of exams a hospital has done.
That table looks kinda like this.
Acc#, Study ID A_1, 123 B_2, 333 A_1, 234 A_2, 666 B_1, 456
I am asked to give a report of the number of studies done for A_% and B_%
A_1 is a bit of a special case as it should either count as 1 study or two depending on billing practices.
I got this to work where A_1 was assumed to be ‘unique’ where in actuality it isn’t always.
Study ID ‘is’ unique!