I have a table with all our deals that contains the following information
Total amount of dealStart dateEnd date
I would like to split this up to a monthly revenue per deal for invoicing and reporting. Most of these deals have a duration of 1 year, b...