Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have table contain date for Start date & End date for vacation, i need to retrieve sum of employee start vacation and the employee End vacation on specific date range or month from specific year.
All Employee start vacation on 2/2010 = 10
all employee end vacation on 2/2010 = 12
maybe some of employee start them vacation on 1/2010 but end on 2/2010 , it's will show on result.
maybe some of employee start them vacation on 2/2010 but end on 3/2010 , it's will show on result.
any idea ??
thanks on advance
Hi there, I think you can accomplish this using set analysis, so if understand correctly you expression should look something like this:
count( {$<EmployeeID = P({$<StartDate = SelectedDate>}) + P({$<EndDate = SelectedDate>}) >} EmployeeID)
That should do the trick. Notice that it will only works on version 9.
Regards.