Calculate FTE and Headcount
This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
Question
Is there a way to report FTE vs. Headcount from the Personnel sheets?
Answer
Headcount is a default calculation on the Personnel sheet. Most clients calculate FTE by taking the total hours and dividing by the number of hours that an employee must work per week to be considered full-time.
This formula can be created as a calculated account on the modeled Personnel sheet. The logic would be something like this:
div(ROW.Hours,40)
You will want to reference ROW.Hours rather than ACCT.Personnel.Hours, as we want to evaluate the FTE per row.