Window Function Lag Requires an Order By Clause

Errors and Warnings
#1

I ran into this error while trying to use the Lag Function do you know what this is?

image
image1562×450 94.2 KB

#2

Hey Zachary!

I believe you are running into this error because you aren’t explicitly sorting your worksheet. You will first have to add a sort and then the lag function should work!