I have scenario in which i need to find out 11 consecutive dates by Employees.
Let me explain in details -
If a employee have 11 consecutive date then count as 1. And check for next 11 consecutive. Only the case of 11 consecutive date, it should be 1.
I want the final result in Employee with their count. if i see result in quarter wise, count should not be greater than 9 for each employee.
Hope you understand.
Please update on the same. i found the logic by table calculation in which i got the those date on which 11 consecutive date was present by employee.
but i need final result in Employee with their count.
So how can i get this.