I'm hoping someone can help me. I have a report where I am pulling two possible values:
{LASTLABS.HDID} in [172763.00, 172764.00]
The values of this field come back as "Level 1", "Level 2" or "Level 3"
However, a patient may have:
1/1/2012 - Level 1 (HDID 172763)
1/2/2012 - Level 2 (HDID 172764)
This table is already built to only pull the most recent value. But, because I am looking at two different HDIDs, it is pulling back the most recent of each. I ONLY want to see the most recent, of either, which would be 1/2/2012 because I need to distinctly count the patients.
Can someone help??