To configure dynamic columns:Using dynamic columns, you can configure unique worksheet columns to display calculated values, or fixed values based on defined conditions. You can use dynamic columns to define calculations and conditions for 20 custom columns. Use custom attributes 1-10 for non-numeric values and 11-20 for numeric values. You use custom columns to display the results of calculations or conditions you define in dynamic columns.
For details about custom columns see Configuring Custom Columns Within Compensation Workbench
Configure dynamic columns to do the following:
Calculation - to display a fixed value based on other numeric columns that use basic math operations such as addition, subtraction, multiplication, and division. For example, New Salary + Bonus = Total Compensation Amount or Last Year Bonus/Bonus Amount * 100 = Percentage Change from Last Year's Bonus
Condition - to display a fixed value based on values of other columns that the application determines based on your choice of multiple relational operators such as ends with, is between, is greater than, is less than.
To configure dynamic columns:On the Compensation Workbench Home page, select the plan to personalize. Select the Allocations task.
Click Personalize Dynamic Columns.
On the Dynamic Columns page, select the column to personalize and click the Define Column icon.
On the Define Dynamic Column page, select the type of dynamic column. You can choose Calculation or Condition.
Enter a value in the Execution Sequence field. The application uses the calculations or conditions in this sequence starting with the lowest number in the sequence.
If you select Calculation as the type of dynamic column in Step 4, then complete Steps 6 to 9.
Select a Column, for example New Salary.
Enter a Fixed Value, for example 6.
Select an Operator, for example, Divided By.
Click Add Another Row and follow Steps 6 to 9 to enter more rows for the calculation. Click Apply to save and calculate.
If you select Condition as the type of dynamic column in Step 4, then complete Steps 11 to 19.
Enter a Column Result, for example 100.
Click the Conditions icon to display the Define Conditions page.
Enter a Sequence number. This is the order in which the application evaluates conditions.
Select a Column for example, Eligible Salary.
Select an Operator, for example, Is Between.
Enter a Value, for example 0. Ensure this value is the same as the value on the worksheet.
Enter a Value, for example 100.
Note: You need to enter this value if you select Is Between as an operator.
Optionally, select a value from the And/Or list.
Click Add Another Row and follow Steps 11 to 19 to enter more rows for the condition. Click Apply to save your work.