Hello,
I have the following issue.
I need to calculate the value of contracts for 2015.
I have a similar table as the one further down, is there a possibility to calculate the value only for the contracts that are "live" in 2015?
How do you calculate the annual contract values?
Does it make any sense?
I do apologize, English is my second language.
Greetings
I have the following issue.
I need to calculate the value of contracts for 2015.
I have a similar table as the one further down, is there a possibility to calculate the value only for the contracts that are "live" in 2015?
How do you calculate the annual contract values?
Contract name | Start date | End date | Value of Contract |
Contract A | 02-07-10 | 02-07-16 | 1000 |
Contract B | 01-03-15 | 31-08-19 | 2000 |
Contract C | 12-12-14 | 05-07-15 | 2000 |
Contract D | 10-05-10 | 05-06-14 | 400 |
Contract E | 01-09-12 | 31-12-12 | 600 |
Does it make any sense?
I do apologize, English is my second language.
Greetings