How to check if Lag(:column, N) points to existing row

miguello — Fri, 09 Jun 2023 18:14:35 GMT

Whern I use Lag(function) I usually do not lag more than one row, so I just include a condition for the first row. But what if I have multiple Lags with different amounts of rows to lag? What would be the best way to check if it refers to an existing row, leave as is, if it lags to before the first row - just return 0? I would try something like Is Scriptable(), but it doesn't' work in this case.

Re: How to check if Lag(:column, N) points to existing row

miguello — Mon, 28 Mar 2022 18:01:37 GMT

if(!(Is Missing(Lag(:column, N))), Lag(:column, N), 0)

topic How to check if Lag(:column, N) points to existing row in Discussions

How to check if Lag(:column, N) points to existing row

Re: How to check if Lag(:column, N) points to existing row