Forum Discussion
Sum per year for date range
Hello, Im stuck on getting the Sum of PricePerMonth for a Name in a year. Name StartDate EndDate PricePerMonth ABC 01/01/2019 30/06/2019 500 ABC 01/07/2019 30/06/2020 600 ...
Sandertjuh what is logic on which year it should count towards. IN 2nd row for ABC, you have added it to 2019 but 3rd row, you are saying it is 2020.
parry2k ,its like a contract so the start date / end date can be any month. I just need to figure out how to get the total amount in a year paid by customer ABC