@Edita_ba wrote:
Hi,
Yes,I'm programing. I try with lag function but without sucess.
Do you mean I need lag for each step (row) calculation?
Please show some example code of what you attempted and what "without success" means for that code. If you had errors or warning messages post the log with the code and messages into a code box opened with the forum {i} icon. Errors often have positional indicators that will often not appear in the main forum windows as the forum seems to strip leading blanks, tabs and sometimes white space in the middle of lines.
If the result is not expected show what the results were and what was expected (values not formula).
Note that use of LAG or DIF functions with in conditionals such as: If Lag(var) > 3 ... is an extremely complicated issue and it is much better to have LAG calls outside of any conditional code structures creating temporary variables that are dropped from the resulting set after the logic is worked out.
... View more