2 Replies Latest reply: May 23, 2012 7:57 AM by Michael Ap RSS

    Help with filtering calculated expressions using above()

      I am trying to filter a table that uses a calculated expression to evaluate the time between successive hospital admissions across a population of patients.


      The Time_Between_Readmissions is calculated as [HospitalAdmissionDate]-above([HospitalDischargeDate]) with PatientID and [HospitalAdmissionDate] as dimensions.


      The calculations work great but I am trying to filter the results to show only those records where Time_Between_Readmissions is within a specific range (say 0-30 days). For each patient, the first admission of each series has a null value for the calculated field (there is no record 'above').


      I have tried using set analysis for the calculated expression and also have tried using a calculated dimension using an 'if' statement.


      Any thoughts about how to filter the table so I only see the records of interest?