Model employees who don't receive an annual salary

Workforce Planning currently supports only annualized measure values. To model hourly paid employees, store the hourly rate and hours worked in custom properties, then use a calculated static measure to derive an annualized salary.

Set up the columns

In the plan setup, add the following columns:

• A custom property Hourly rate. For example, $35 per hour.
• A custom property Number of hours. For example, 40 hours per week.
• A static measure with a formula that calculates the annualized salary. For example, Hourly rate × Number of hours × 52 weeks per year.

Use a static measure (rather than an effective-dated measure) for the formula. Formulas work best when they don't change over time.

Change the underlying properties (Hourly rate and Number of hours) over time to reflect changes; the formula recalculates automatically.

If you need to model varying weeks per year, add a third custom property (for example, Weeks per year) and reference it in the formula. This lets you increase the number of paid weeks in some years to reflect your business calendar.

Enter hourly employee data

When you add or import employees, enter values for the Hourly rate and Number of hours columns instead of a direct salary figure. The static measure calculates the annualized salary automatically.

If an employee's hourly rate or hours change over time, edit the property values from the effective date. The recalculated salary flows through automatically.

---

Learn about how the values are published

When you publish the plan:

• The calculated annualized salary is spread into daily transactions in the Flex Modes database, using the configured spread method.
• The underlying Hourly rate and Number of hours properties are published alongside the salary transactions.

The properties are available for analysis:

• In Flex Modes, they are visible in the transaction view alongside the calculated salary.
• In Budgets & Forecasts, use a Reference tab in a multi-measure row or the output view on a Planning tab.

Properties don't aggregate meaningfully at higher levels. For example, summing Hourly rate across employees produces a total that isn't a real hourly rate. View properties at the employee level for accurate values.