Dear All,
I hope someone can help with my problem. I have attached an example application for info.
I have two contracts
Contract A £2,000,000
Contract B £4,000,000
for which I need to calculate the monthly revenue (by the number of days in each month). This on the face of it seems straight forward.
Where it gets slightly complicated is that each contract has an annual increase (CPA) each year from a specific date -
Contract A 25-Oct-2010 & 25-Oct-2011
Contract B 17-Feb-2010 & 08-Feb-2011
My problem is multi fold -
(1) My interval match doesn't seem to work so when I am trying to match the CPA (contract increase) date against the month it appears it, it doesn't recognise it.
(2) Where I want to calculate the value of the increase it only shows the value for the one month, whilst I want to calculate the cumulative position.
(3) I only want to calculate the revenue increase for contracts where the CPA (contract increase) date is after 1 September 2010.
Please let me know your thoughts folks !
