Using last function

building reports webintelligence
1

Hi Everyone,

In the last row of every block i am using Last function for all the coloumns…
Basically I have to show results for patients on the basis of “Last Glucose level performed”
like u can see in the screenshot for MRN"0000494505"
for this patient the last glucose level was 174…

i created a variable =Last(([Clinical Event Numeric Result])) ForEach([MRN- Organization]) Where( [Clinical Event]=“Glucose Level”))
but when i try to create the same for date…it gives me a multiple value error…
The result shuld luk like

MRN ORganistioan Clinical Event Clinical Event Numerci Result Clinical Event PerformedDate/Time Nurse Unit

0000494505 Glucose Level 174 06/08/20120 1:40am NICU

Any suggestions ???
:?:

lucy.online :us: (BOB member since 2012-04-03)

2

Please try Max for date. It may work.

Best of Luck…
:mrgreen:

AFAF :india: (BOB member since 2012-07-13)

3

ok thanks let me try… :+1:

lucy.online :us: (BOB member since 2012-04-03)