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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Turnover -Month on Month

Summary: I am looking for calculating turnover 12 months from a certain date month by month. But I want the period start date to remain the same as the start month of the 12 month period.

I have calculated the running sum for termination, but I am unable to get a static period start headcount for each month.

So basically every when I am looking back say as of 30-Sep-2021, so for 01-Oct 2020 until 01-Sep-2021 the period start headcount should be as of 01-Oct-2020 and then I calculate the turnover rsum(term headcount)/period start(default)+ period end/2


Is there way to achieve this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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