Overview of Dynamic Columns in Workforce Compensation Plan Worksheets

You can calculate and display values that vary by individual for many worksheet columns, including most percentage columns. You do this by building conditional expressions for the appropriate columns. For example, you want to base the bonus eligible salary on the current annual salary.

You can also determine the values in one column using values in another column. For example, as part of the annual bonus review, you want to show managers the bonus target amounts to consider during allocations. You build a dynamic calculation that varies the Bonus Target Amount by each individual's performance rating. For example, people with an Outstanding performance rating have a bonus target amount that's 10% of their bonus eligible salary. People with a Meets rating have an amount that's 5%.

Validation and Testing

You can validate each condition as you build it and test all conditions and column results on the Dynamic Calculation page. You can also export the conditions on the page to review and validate them outside of the worksheet configuration.

Column Information Sourced Outside the Plan

When the information source for a column is outside the workforce compensation plan, you might need to run the Refresh Workforce Compensation Data process. For example, dynamic columns that depend on the performance management overall rating might not show the actual performance rating until after you run the refresh process.