Sales Configuration > About Sales Configuration Rule Table > Interpolation
  
Interpolation
Interpolation is a method by which the system can determine values for result variables that lie between the specific values that you specify in the rule table.
This method only works for rule tables with two numerical conditions (IF clauses) and one numerical result (THEN clause) that have the interpolation switch turned on. Only when real numerical values are entered for the conditions and the result, interpolation works. It cannot handle complex formats such as ranges, lists, and exclusions. If both conditions exist in the rule table, interpolation returns the specified result, but if one or both of the conditions cannot be found, simple linear interpolation is used to calculate the result.
For such numerical value rules, the rule table only defines the measure points. The following table shows Production-densities (result) for a given Density (condition 1) and Width (condition 2).
Note: This is a table of values, not an example of a rule table.

Production Density
 
 
Width
Density
1000
1500
2000
0.8
25
30
40
1.0
32
35
40
2.0
36
42
48
Example: If the Density is 0.8 and the Width is 1500, the production density would be 30. However, if the Density was 0.9 and the Width was 1250, there is no specified value in the rule table. Without interpolation, the rule could not provide the required result.
The next table is similar to the previous one, but expanded with interpolated values for production density.
Bold values represent the measure points from the previous table.
Italic values represent condition-values and calculated result-values that do not exist in the rule table.

Production Density
 
 
Width
Density
1000
1250
1500
1600
2000
0.8
25
27.5 (a)
30
32
40
0.9
28.5 (b)
30.5 (d)
32.5 (c)
34
40
1.0
32
33.5 (e)
35
36
40
1.2
34
36.25
38.5
39.6
44
2.0
36
39
42 (f)
43.2
48
The letters (a) to (f) identify particular cases that are explained later.