years
1 Topic
Allocating contract amount over multiple years
Hello, I have an interesting question - Working with contracts that are generally 1 year but sometimes they go multiple years. Each contract has a contract id, start date, end date, and amount. I need to show contract expenditure by year. Straight forward when contract is for one year i.e. Jan 1, 2022 thru Dec 31, 2022. How do i allocate the amount by year if a contract starts on Feb 1, 2021 and ends on Jan 31, 2024. Many Thanks! PavSolved914Views0likes4Comments