Forum Discussion

bdeleur's avatar
bdeleur
Icon for Helper III rankHelper III
3 years ago
Solved

Discharge department

Hi,   I want to make a report witch contains the following information. Out of a big data file I want to extract the follow up department. So I have department A and how many have a transfer (dis...
Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    bdeleur 
    For now this is what I can provide you. The difference between Count 2 and Count 3 is that count 3 shall not count discharged from same department unless there is a discharge date. The difference shall not be noticed using the sample data as there are no blanks in the end date.

bdeleur's avatar
bdeleur
Icon for Helper III rankHelper III
3 years ago

The discharge out of hospital is only relevant when there is no next department. Then "discharge" needs to count as an movement, but only for the last deparment for that patient.

 

Every transfer needs to be counted, even they move back to a department

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Perhaps try tamerj1 solution if it works what you looking for. 🙂 
If not, let us know.