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?