7 Replies Latest reply: Aug 12, 2011 11:53 AM by Sakuranbo RSS

    Set Analysis newbie question

      I have a situation where I have the following current selections:

       

      image1.JPG

       

      I have a table that counts the visits for this scenario such as:

       

      image2.JPG

       

      Now I also want a table that counts the visits but with Akber M Ashraf as the Admitting Physician instead of the Attending Physician without affecting the current selections, ie. Disregard the attending physician selection and add an attending physician selection. I believe this can be done with set analysis. I have tried the below, but it doesn’t seem to give the right answer. Can you look at it please and give feedback.

       

      =count({$<[Attending Physician Name]=, [Admitting Physician Name]={"Akber M Ashraf,*"}>}[Patient ID])