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.