Hi,
I have a time ordered set of data that I want to calculate a column using one row's data relative to an earlier row. It seems like I should be able to do this using the math formula node but perhaps I just don't have the right syntax.
For example I would like to create a new column: (column A.row n) / (column A.row n-12)
Any ideas would bbe appreciated.
This can not be done directly unfortunately, you will need to use the column lag node first to generate another column which has the values offset by the desired number of rows. Then use the maths formula node with this new column.
i hear the java snippet nodes can call on rows ahead and behind the current row. But the syntax needed in these is beyond me unfortunately.
hope this helps,
simon.
This will work. Thanks Simon
Cheers
D.