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...
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.