Cumulative function not showing value when most recent period has no values

I am trying to write a cumulative function for the dark blue bit (Number of Beds) which tracks the light blue bit all the way to the end. Essentially, even in years where no beds were added (I.E. 202...