1 Reply Latest reply: Nov 22, 2017 3:33 PM by GE US Enterprise Solutions RSS

    Set analysis help needed

    GE US Enterprise Solutions

      Hi,

       

      I am working on a set analysis expression and have been struggling with the last piece.

      I appreciate all help.

       

      =aggr

      (

           only

           (

                {$

                     <PatientName=P({$<ScanType={'XR'}>}PatientName)>

                          *

                     <PatientName=P({$<ScanType={'CT'}>}PatientName)>

                }

           PatientName

           ),

      PatientName

      )

       

      Existing expression correctly identifies all patients who had both 'XR' and 'CT'. I need to further modify it, so that it only looks for patients who had a XR, within 40 days prior to the CT.

      I have a field, ScanStart, that tells me when the scan took place.