
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calculating an attrition rate
Hi,
I am trying to calculate and visualise an attrition rate which shows me the rate of attrition month-on-month, but have been unable to calculate it correctly.
I have gone about this by creating my own fields of 'Headcount' and 'Leavers' in order to write the expression. What I have so far, which doesn't give me the right results:
RangeSum(Leavers)/RangeAvg(Above(count(HeadCount),0,12))
'RangeAvg(Above(count(HeadCount),0,12))' correctly displays a moving average of headcount, which is what I want, however 'RangeSum(Leavers)' breaks the formula. The attrition formula I am trying to recreate is:
Sum of leavers (April 2017 - March 2018)/Average Headcount (April 2017 - March 2018)
Any ideas?
Thanks
- Tags:
- rangesum

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this
RangeSum(Above(Count(Leavers), 0, 12))/ RangeAvg(Above(Count(HeadCount), 0, 12))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have tried that variation but it didn't work 😞

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able to share a sample which we can take a look at?
