Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to derive Running Average of Monthly Attrition rate in one OTBI report — Cloud Customer Connect
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 derive Running Average of Monthly Attrition rate in one OTBI report

Accepted answer
101
Views
7
Comments
edited Apr 30, 2018 5:23PM in Reporting and Analytics for HCM 7 comments

Summary

In one OTBI report, I would like to see, the monthly attrition rate and monthly running average attrition rate

Content

Can anyone please help me how to do this? I have highlighted the needed column yellow in the screenshot and also attached my current report XML.

Monthly Average Attrition Rate = (Sum of terms till that month)/(Sum of Adjusted Head Count till that month)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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