Interpolation between Years

[mark_paul]

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

[mark_paul]

@afv2688 , Still not getting correct values

Thanks,

Mark

[mark_paul]

@RolandSchubert ,

I see that same ID will repeat multiple times

Thanks,

Mark

[afv2688 · Accepted 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

[RolandSchubert · Accepted solution]

Accidentally removed the "Group by" on ID in the Multi-Row Formula - now it's back and there is only one result for each ID.