Hi,
I am having a hard time comparing a running sum to the same time last year if there is a no value.
The beastmode I am using to get the running sum for each year is as followed.
SUM(Count(ReportNumber
)) OVER (PARTITION BY Year
ORDER BY AccidentDate
)
However, not all accidents occur on the same day of the year, so my question is how can I modify the beast mode to find the max value leading up to the day of the year.
I attached a photo below to show you the issue. In the prior year coulmn I am trying to carry the two down until it becomes 3.
Is there an easier way to accomplish this? Thank you!