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

How to count terminations as effective on termination date itself?

Accepted answer
87
Views
8
Comments
edited Feb 19, 2020 4:29PM in Reporting and Analytics for HCM 8 comments

Summary

Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term action (i.e. 1 day AFTER the term date)

Content

While creating an analysis with a pivot showing Head Count, Hires, and Terminations by month, I noticed that some of the monthly term counts were inconsistent with other reporting I'd previously done in excel. I realized that for any termination on the last day of a period, the analysis pivot was counting it within the next period.

I understand why this occurs from a technical standpoint: the "Termination Count" measure is referencing the effective start date of the term action. However, this is inconsistent with how we've been reporting on terminations. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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