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

Note:

Only expressions that refer to goals can be used as tiers of a rate table. For example, expressions such as Measure.Target, Measure.Target * 0.5, Measure.Interval Target, Measure.Interval Target * 0.8, and so on.

You can verify if an expression can be used as a tier is by looking at the usage details of the expression. An expression that lists tier for rate table in the usage details can be used in an expression-type rate dimension.