7 Replies Latest reply on Jan 5, 2017 6:09 AM by Jeffrey Kritzman

    Help with counting emergency visits please

    Mihaela Farcas

      Hi,

      Due to the privacy considerations I have made up an excel table.

      I would really appreciate if someone can give me a solution to

                - count emergency visits for each patient that was discharged yesterday (i.e. 21/12/2016) for the last 6 months

      each patient has a unique chart number, and each chart number has multiple visits (account numbers)

      - if the patient has 0 to 3 visits prior to admission within the last 6 months than give me the count

      - if the patient has more than 3 visits than 4

      - if the last emergency visit triggered the admission do not count

      please check the excel table attached