This is not my solution, I got it from another forum
Ok, try this. I am going to assume that you have access to Universe designer and that the 4 columns of data are datatype "date". In designer, create "Admit Date" by concatenating admit date and admit time. Do the same for "Discharge Date"...
Hello,
I get lab records listed below. What I want to do in Crystal is compare the first record to the last i.e.result 1.9 to 3 and to see if the results are greater than 1(which in this case is true). Does anyome know how to look at records for one patient can compare the first and the last...
I see what you are saying except patients get moved around i.e. new bed numbers and you get a new date entered. I would be overcounting the number of admits to the unit.
The patients are all on the same floor, but different beds sometimes. What happens is that they can go from one bed to another on the same day and these patients should be counted only once. You also have patients that can stay in the same bed their whole stay and they should be counted only...
Yes sort of
What I am trying to do is if the account number
is the same i.e. same patient and the DATE ENTERED UNIT =
the DATE LEFT UNIT of the next line then give me a 1.
If the account number of the enxt line match and the DEU and the DLL don't match also give me a 1.
Sometimes a patient...
if onfirstrecord then 1 else
if (previous({ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}) ={ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}
and previous({ENC_ICU_ADM_VIEW.DATE_ENTERED_LOCATION}) = {ENC_ICU_ADM_VIEW.DATE_LEFT_LOCATION})
then 0 else 1
The above code worked sort of. I am getting a 1 for the first...
if not onfirstrecord then
if previous({ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}) ={ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}
and previous({ENC_ICU_ADM_VIEW.DATE_ENTERED_LOCATION}) = {ENC_ICU_ADM_VIEW.DATE_LEFT_LOCATION}
then 0 else 1
I can get a 1 on all the records except the first one so I can get a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.