Review the reporting choices that protect a workforce snapshot from double counting. The as-of date resolves history, Employee Class defines the population, and Employee ID provides the person key. Headcount and FTE use that same population but summarize it differently. A department transfer should move distribution without adding another person to the company total.
The independent tasks mix table reports, metric controls, saved layouts and exports. Read the requested date each time instead of keeping the previous report's date by habit. Preserve the fields that make the spreadsheet traceable. A valid zero for an empty department should remain zero. You are reviewing existing reporting tools here, so choose the appropriate view rather than adding a new metric definition.