Forum Discussion
rolling sum
Anonymous
sry, I fixed this. Please see the attachment.
Anonymous
please see the attachment. hope this is helpful.
Hello ryan_mayu
Thank you for your reply. I noticed that your solution has an error. More specifically, it summarizes the values per year, but it ignors the breakdown per benefit type.
For example, the value of project PR1, hard benefit 1, year 2019 is 104. Your solution shows 212 instead, which is the sum of hard benefit 1 (value 104) and hard benefit 3 (value 108) for year 2019.
Thank you,
George
Anonymous
sry, I fixed this. Please see the attachment.
Hello ryan_mayu ,
I really appreciate your quick response.
Your approach is perfect.
Please allow me one more question before I accept it as the solution. May I only ask if there is a way to produce the same solution, without the additional tables/relationships that you created?
Thank you,
George
Anonymous
yes, that was my first attempt.However I found what I got is not as same as what you need. So I tried another workaround to get your expected output.