Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to count terminations as effective on termination date itself?
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.
1