Populating Sales Figures By Contract Length

Aim – Take the “One Month Figures”, look at the revenue start date, and calculate the sales by the “Contract Length”, broken down by the year in the “Revenue_State_Date”.

For Example

As the Revenue_State_Date starts on 01/01/2015, you have 12months of full trading in 2015, so you need to calculate 12 months of sales,

This needs to be spread out over the contract length

For eg
YearSales Months
2015£2,914,033.3312
2016£2,914,033.3312
2017£2,914,033.3312
2018£2,914,033.3312
2018£1,457,016.676
Total£13,113,150.0054

My query is

SELECT
[Total_Contract_Value__c] as TCV,
[Contract_Term__c] As Contract_Length,
[Revenue_Start_Date__c] as Revenue_State_Date,
[Total_Contract_Value__c]/[Contract_Term__c] as One_Month_Sales
FROM [FDMS].[Dan].[Raz_Reporting_LCS]
where ID = '006a0000015qcGsAAI'

Which produces following results

TCV £13,113,150.00
Contract_Length 54
Revenue_State_Date01/01/2015
One Month Figures £242,836.11