Hi, I have a connected table 'Employees' from Intacct where from I have pulled in employee data with the Start Date and End date. Start date means joining date and End date means the date employee left. I need to produce an attrition ratio report by month with rolling 12 months. Every month the period of calculation would be for example , Jan'16 (period 02/01/2015 to 01/31/2016), Feb'16 (period 03/01/2015 to 02/29/2016), Mar'16 (period 04/01/2015 to 03/31/2016)....and it goes on...
The formula is
Attrition ratio = [Employee left during the period / ((Opening Balance of head count at the start of the period + Closing balance at the end of the period) / 2)
How should I do that? And which report selection would be best in this case?