How to find the difference/variance between previous and current row values in detail band ?

[venkateshreddy080]

Dear Team,

 

Can you please let me know How to find the difference/variance between previous and current row value in detail band?

I created variable with calculation type as Variance and placed this variable in detail band, but it is not giving the correct variance b/w previous and current row values.

Please let me know the steps to solve this issue.

 

Thanks

Venkatesh

[zh3ntil]

Hi,

You can achive this by using 3 variable. For example create variable like below. Sort is important. Beacuse jaspersoft calculates the variable by orders.

1. vSalesCurr =  $F{Sales}
2. vSalesDiff =  $V{vSalesCurr} - $V{vSalesPrev}
3. vSalesPrev =  $F{Sales} (you can define 0 as initial value)

While jasper processing the vSalesDiff,

• vSalesCurr holds current value because it is calculated already
• vSalesPrev holds the previous value because it is not calculated yet and still holds the previous value. 

That's the trick.