Skip to Content
0
Former Member
Nov 08, 2012 at 01:38 AM

Max Completion date for a Course

25 Views

Hi,

I am working on aBI 7 BEx query, where I have completions data for every course and with respect to every employee ID.

If an employee has completed the same course 3 times with in a year or across years, I have 3 records with three different completion dates for the that course and for that employee.Ex, first completion date is 01/01/2011, second is 05/31/2012 & last date is 12/31/2012.

When I run the query , I am able to see all the three records with three different completion dates.

Now what I want is new key figure " Max Completion date", which will be 12/31/2012 for all the three records, next to completion date key figure on the bex query.

Please let me know , how I can achieve this functionality.

Thanks

DM