I need to calculate the turnover rate within 12 months, the formula is:
*total employees departure filtered by period/average total employees in the last 12 month filtered by period
I have the total employees departure calculated field, but I don’t know how calculate the average of the total employees when I select a specific period.
For example if I select the period 202211 the formula is :
*total employe departure in 202211/average total employees in the last 12 month between 202110 to 202211
Please if someone can help me, I will be very grateful