I agree with everything said. Unfortunately I am working within a system that i do not have control of changing.

The reason for the post was to find out more about how Lead and Lag functions work and if they recalculate when a row is updated.