AC Report
Operator Category Fields Value
>= Vital Signs (most recent) Systolic Blood Pressure 0
>= Vital Signs (most recent) Diastolic Blood Pressure 0
= Notes & Encounters Encounter Date 01/21/20
Click the "Show All Query Results" checkbox to show the values in the results.
Important to note this report should be run daily, because it's going to pull the most current BP values as opposed to the BP values for each visit date. For example, if a patient was seen on January 1 and on January 3, it'll pull the January 3 BP results regardless of which encounter date you're looking up. (I hope that makes sense).
In Excel, here's the formulas (assuming the Systolic BP value is in Column E and the Diastolic BP value is in Column F):
Systolic BP
=IF(E2<130;"3074F";IF(E2>=140;"3077F";"3075F"))
Diastolic BP
=IF(F2<80;"3078F";IF(F2>=90;"3080F";"3079F"))
