Help

Monthly revenue forecassting

Topic Labels: Formulas
711 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Shilpa_Wymer
4 - Data Explorer
4 - Data Explorer

Hi,

I’ve got the same issue as this https://community.airtable.com/t/calculating-monthly-revenue-from-start-and-end-dates.

But I can’t locate the answer.

So I have a calculated column which shows what’s left to pay on a contract and I have a calculated column showing number of months left. I’d like to build this out to show the monthly revenue based on a equal monthly amounts.

How do I then get it to populate months from there?

Hope that makes sense.

Shilpa

3 Replies 3
Yasutaka_Ito
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @Shilpa_Wymer,

Would you elaborate a little more on your question, by mentioning what kind of columns you have in mind? Will be able to help you based on that.

Shilpa_Wymer
4 - Data Explorer
4 - Data Explorer

I have two synced fields - one shows the remainder left to bill on a project and the other the number of months remaining on a project.

I then want to show the monthly amount we are forecasting to bill.

i.e I have £1000 left to bill and there are 2 months left in the project, so in column July and August i want to populate with £500 in each column.

Does that make sense?

Thanks

Shilpa_Wymer
4 - Data Explorer
4 - Data Explorer

Hi, I haven’t had a response back - please could you let me know if you know how i can get this to work.

Thanks