Hi All,
I have a requirement to display latest meeting status of an employee. But in the report I am getting 2 records for an employee, the meeting date is same but the Last Update Date is different.
I found some info on MOSC where they said we can use the filter as LAST_UPDATE_DATE = MAX(LAST_UPDATE_DATE BY EMP_ID), but it didn't work.
I also tried with Meeting_Id instead of Last_Update_Date and also tried RANK() & TOPN().
In the report, the fields are coming from 3 Subject Areas, so when I use RANK(), TOPN() or the filter above, we are getting ODBC errors and when used in a simple report, the output doesn't change.
Any pointers on this will help a lot.
For ex:
Emp Meeting Id Meeting Date Last Update Date DATE_FROM DATE_TO Performance
ABC 100002 15-06-2016 15-06-2016 15-06-2016 31-12-4712 Above Expectations
ABC 100003 15-06-2016 24-06-2016 15-06-2016 31-12-4712 Met Expectations
Expected Output:
Emp Meeting Id Meeting Date Last Update Date DATE_FROM DATE_TO Performance
ABC 100003 15-06-2016 24-06-2016 15-06-2016 31-12-4712 Met Expectations
Thanks,
Divya
