Difference between consecutive rows(next-current)

sachinr

HI Birt Guru's,

I want to show difference between two consecutive rows in my report.

Please let me know how to do that,

Following is the scenario for the same.

Actual Column Difference Column
10 30
40 -20
20 30
50 30
80 0


Eagerly waiting for the solution.

Please let me know, if this is possible in BIRT.

Tubal

<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/21623-calculate-from-previous-row/'>This post</a> tells you how to create a computed column with the previous row's value.<br />
<br />
Then you can just subtract your current row's data from the computed column to get your difference.