Use Dynamic Tier Expressions for a Rate Table

This example shows how to use an expression to create rate dimension tiers dynamically.

Scenario

You want to pay bonus amounts using percentage of quota attainment.

Solution

Instead of creating a static set of rate tiers to determine the amount, such as 0 to 25 percent, 25 to 50 percent, and so on, in the Compensation Plans work area do these steps:

1. Create a rate dimension of type Expression.

2. Define the tiers using calculation expressions as shown in the following table.

   From Value	To Value
   0 percent * Quota	25 percent * Quota
   25 percent * Quota	50 percent * Quota
   50 percent * Quota	75 percent * Quota
   75 percent * Quota	100 percent * Quota
   100 percent * Quota	9,999,999 percent * Quota