Saturday, 6 May 2017

Get then other row values in Datawindow Expression

We can access column values of other rows than the current one, by using the [] array notation. 

E.g., a computed column giving the sum of a column in the current row with another column contained in the previous row, could have the expression:

if( getrow()>1, Value1+Value2[-1], Value1 )


Thanks,
Pushparaj

No comments: