FieldValue() function not working

[somenathroy]

Hi All,

I am trying to write an expression which will extract the field value, skipping two row in forward from the current row on a Straight table. For example, I want to extract the value of the 3rd row of a particular column when the current row number is 1 of a Straight table (see attached file). I am trying to do this using FieldValue() function. But it is not working as expected. Any way out would be appreciated.

Thanks

Som

[disqr_rm]

Try

     below(TOTAL SRL_NO, 2)

in your expression.

Similarly you could use above() to get previoue line values.