I actually did try Lag and Lead functions to solve this problem but netsuite kept giving invalid expression on me, could be I wasn’t writing it correctly.