Configuration Experiment #V5
Goal
The goal of this experiment is to help you understand how to use custom variables in your configuration. For this challenge, you will use a demo workspace and enter some configuration. When asked to write down something, please copy the value to a document (along with the step #), as you will be using those values later on. 
Difficulty
Easy.
Steps
- Create a demo workspace
 - Go to Plans > All Plans
 - Edit plan "One-Off Sales Contest"
 - Go to the Custom tab
 - Add a custom variable like this

- Read about lookup tables here
 
 - Go to the Incentives tab
 - Delete all attainment levels
 - Add one tier (threshold of 0%)
 - Add a per-transaction reward to this tier with this formula

 - Save plan changes
 - Go to Calculations > All Calculations
 - Re-run the calculation (with delete)
 - Open the calculation
 - To the the Credits tab
 - Click on "Export Credits" (choose "Export All Fields")
- Compare commission amounts vs. quantities
 - Do calculated commission payouts match expected ones?
 
 
Key Learnings
- It's possible to configure custom variables which contain lookup tables. In this scenario, we configured the custom variable as a plan-level custom variable, but we could also have configured it per-user or per-team.
 - This makes it possible to vary those lookup tables over time (i.e. set different values and effective dates)
 - A custom variable containing a lookup table can be loaded into a regular var $something variable.
 - The Lookup() function takes a/ the value to lookup and b/ the custom variable holding the lookup table.
 
Related Articles
 
Configuration Experiment #V3
Goal The goal of this experiment is to help you understand how to use custom variables in your configuration. For this challenge, you will use a demo workspace and enter some configuration. When asked to write down something, please copy the value to ...
 
Configuration Experiment #V2
Goal The goal of this experiment is to help you understand how to use custom variables in your configuration. For this challenge, you will use a demo workspace and enter some configuration. When asked to write down something, please copy the value to ...
 
Configuration Experiment #V1
Goal The goal of this experiment is to help you understand how to use custom variables in your configuration. For this challenge, you will use a demo workspace and enter some configuration. When asked to write down something, please copy the value to ...
 
Configuration Experiment #V4
Goal The goal of this experiment is to help you understand how to use custom variables in your configuration. For this challenge, you will use a demo workspace and enter some configuration. When asked to write down something, please copy the value to ...
 
Configuration Experiment #T1
Goal The goal of this experiment is to help you understand the time dimension in calculation mechanics. For this challenge, you will use a demo workspace and alter the configuration. When asked to write down something, please copy the value to a ...