Multi-Row-Formula Tool and the Row-1/0/+1 function

Cela

Hi everybody,

I was wondering if it's possible to modify the row expression from [Row-1:Field1] to something like [Row-2:Field1]. I tried the obvious and it didn't work that way. Is there a different approach I can take inside the MRF Tool or do I need to solve this issue in a different matter?

Background information as to why I am asking:

I am trying to make complex calculations by using two cells of different rows and sometimes also different columns and display the output in a new column. This has worked like a charm for anything within the -1/0/+1 range of cells I was referring to but it starts getting tricky once I try to do that with rows that are outside that range.

Thanks in advance!

DataNath

Hey @Cela, as standard, the 'Num Rows' configuration is set to 1 which allows you to look forward & backward 1 row (+1/-1):

If you just increase this, you can start to look back/forward N rows, where N = whatever you have in 'Num Rows', like so:

Hope this helps!