Click to See Complete Forum and Search --> : SELECT most recent value


valkyriex
August 3rd, 2007, 11:31 AM
Hi,

I'm running a medical report where I need to find patients with BMI value = xx. However, it has to be the most recent BMI reading. That means, if a patient has a BMI reading of xx in March, but yy in June, then that patient should not be included in the report.

Does anyone know of a formula that can specify such criteria?

Madhi
August 20th, 2007, 08:47 AM
Make use of selection formula

CR.selection formula="not (your condition here)"