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.
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?