You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Sick Leave Duration greater than XX days over a rolling period

Received Response


We are trying to report on employees who have recorded more than 40 days of sick leave in a rolling 365 day period.

Content (required):

We have used Leave Duration and with no filter on this shows correct results, but when we add a filter like 'greater than 40' to the Leave Duration field it restricts the results to instances where the duration per instance is 40 days rather than the complete total of absences. For example the top record here should actually show over 200 days

Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!