We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
92
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!