Skip to Content
Former Member
Jul 29, 2009 at 11:07 AM

Exception - More than three absences in 6 months


In my query I have absence data. In the rows I have the employee and the start and finish dates of their and then in the key figures I have the actual number of days absent. I want the report to highlight if an employee has m3 or more absences in a rolling 6 month period. How do I go about doing that?