hello community, I need to perform a validation of consecutive values in the same column, basically I have something like this:
ID test
1 -
2 1
3 1
4 1
5 1
7 2
where the ID is the number that should be consecutive, and the test is the formula result of substracting ID previous row… and so in a huge list I need to locate those “jumps” such in the last item where the difference is 2 and not 1.
do you have any idea of how can I add that formula? in excel is as easy as “=D2-D3” but cannot figure out an option here…
in addition to what @HansS provided this and similar calculations can be done using Moving Aggregation node. In your case Window type is Backward, window length is 2 and Aggregation method is Range.