I have a table with the following format:
Field1 | Field2 | Field3 |
1 | 1 | 10 |
2 | 3 | 8 |
3 | 7 | 5 |
4 | 15 | 1 |
I want to overwrite every value with the difference between that value and the value in the previous row, for every field. (For an arbitrary number of fields.)
Thereby creating the following table:
Field1 | Field2 | Field3 |
0 | 0 | 0 |
1 | 2 | -2 |
1 | 4 | -3 |
1 | 8 | -4 |
I assume the key is the multi-row formula tool but I'm afraid the needed logic is a bit beyond me.
Would appreciate any help. Thanks a lot.
Solved! Go to Solution.
Works like a charm, thank you Prakhar.