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
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:
Post a Comment