I've attached a workbook that includes some inline commentary. Basically, I used a couple of table calculations to work backwards along week and determine the "first" good value (which is really the last).
No More Final 0s.twbx.zip 14.0 KB
Thanks for that Joshua - wow that was really non-self evident but I can totally follow what you've done. Worked a treat on the data set and it does exactly what I need it to. Thanks loads.