# Interpolate Values in Report

**URL:** <https://community.fibery.io/t/interpolate-values-in-report/6496>\
**Category:** Get Help\
**Created:** [August 11, 2024, 9:43am UTC](https://community.fibery.io/t/interpolate-values-in-report/6496 "2024-08-11T09:43:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicolasscheel](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nicolasscheel](https://community.fibery.io/u/nicolasscheel)\
**Post date:** [August 11, 2024, 9:43am UTC](https://community.fibery.io/t/interpolate-values-in-report/6496/1 "2024-08-11T09:43:44Z")

</div>

Hello,  
I’m trying to create a report on wealth over time. Let’s say we have stocks and real estate. We have data points for stocks in may, June, July, August and September. We have data points for real estate in May and August.  
How can I use the data point for real estate of May in the months of June, July and August? The value of real estate is not zero in these months.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/8/87e048f64d43cdea285face27826e4483e4250c4.png)

Appreciate any help or ideas!  
Thanks, Nicolas

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 11, 2024, 10:29am UTC](https://community.fibery.io/t/interpolate-values-in-report/6496/2 "2024-08-11T10:29:16Z")

</div>

> [@nicolasscheel](#):
>
> We have data points for real estate in May and August.  
> How can I use the data point for real estate of May in the months of June, July and August?

I assume you meant ‘in the months of June and July’ (since you have a value for August).

Did you want the values for June and July to be the same as the value for May?  
Or did you want to have true interpolation, i.e. the value in June would be 1/3 of the way between the May and August values, and the July value would be 2/3 of the way between the May and August values?

---

<div class="post-metadata">

**Author:** ![nicolasscheel](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nicolasscheel](https://community.fibery.io/u/nicolasscheel)\
**Post date:** [August 11, 2024, 11:50am UTC](https://community.fibery.io/t/interpolate-values-in-report/6496/3 "2024-08-11T11:50:03Z")

</div>

Sorry, you’re right, June and July. Thank you!

For June and July, the best solution would be 1/3 and 2/3, so in my example

May: 300  
June: 266  
July: 233  
August: 200

If that’s not possible, the next best thing would be  
May: 300  
June: 300  
July: 300  
August: 200

And, just to go all around, in September take the value of the last entry, i.e. 200

Does that make sense?

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [August 12, 2024, 9:31am UTC](https://community.fibery.io/t/interpolate-values-in-report/6496/4 "2024-08-12T09:31:57Z")

</div>

Unfortunately, I don’t think this is possible. I think the only workaround would be to (perhaps automatically) create entities to represent the intermediate/extrapolated data points.

---

<div class="post-metadata">

**Author:** ![nicolasscheel](https://avatars.discourse-cdn.com/v4/letter/n/b38774/32.png) [@nicolasscheel](https://community.fibery.io/u/nicolasscheel)\
**Post date:** [August 12, 2024, 3:24pm UTC](https://community.fibery.io/t/interpolate-values-in-report/6496/5 "2024-08-12T15:24:02Z")

</div>

Okay, not the hoped-for-answer, but it brings clarity. Thanks for your help!