Checking previous initials

[GMAN33]

Hi Gang,

I have one table that collects patient data grouped by patient by visit number. Patients can have muliple visits. At each visit, the doctor that is assigned needs to inital the records. I need to check at each visit if the initials are the same for the previous record. But I don't want to check the previous patient data...so the formula would need to reset on each group

Any help would be appreciated...CR9

Thanks

 

[lbass]

Try something like:

if {table.patientID} <> previous({table.patientID} then "" else
if {table.initials} = previous({table.initials}) then "Same" else "Different"

-LB

 

[GMAN33]

That worked great...thank you very much