Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

FTE and Headcount

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.