Hi,
How to achieve interpolated between years and get the values?
Source 1:
Year | Value |
1 | 1.3456 |
2 | 1.45678 |
3 | 2.223456 |
4 | 2.98765 |
5 | 1.9876 |
6 | 1.32456 |
7 | 1.435678 |
8 | 2.213456 |
9 | 0.98765 |
10 | 2.123456 |
Target:
ID | Year_1 | Interpolated_value |
100 | 2.124 | Interpolated (((2.223456-1.45678)/(3-2)) * (2.124-2) + 1.45678) =1.551847824 |
101 | 3.987 | ((2.98765-2.223456)/(4-3)) * (3.987-3) + 2.223456 = 2.977715478 |
102 | 6.12 | Interpolated between 6 and 7 |
103 | 5.432 | Interpolated between 5 and 6 |
104 | 9.765 | Interpolated between 9 and 10 |
105 | 8.432 | interpolated between 8 and 9 |
106 | 7 | 1.435678 |
107 | 4.378 | interpolated between 4 and 5 |
Thanks,
Mark
Solved! Go to Solution.
Hello @mark_paul,
getting here the exact same results. If there is one which differs from yours pleas tell me to see where to perform the change.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regards