Lag inside an If statement , best practice?

Olek P

Hi

I need to put a lag function inside an IF statement. What is the best practice for this to optimize model performance? Should I break it into to line items? Or would it be more efficient to do: IF NOT x > y THEN 0 ELSE LAG() ?

Thank you

Ashutosh

if you are using only one & two if else loop then u can incorporate in same formula. But there are nested if & else then break it.

Please read below article if u r using nested if else

Nested if else