variable with initial value and re-use same variable?

[raul.mendez]

Hi,

I'm trying to have a variable that displays the total of products, so I have the following:

Parameter: stock_initial (The quantity initial)

Variable input: stock_in (This return the quantity of an input product)

Variable output: stock_out (This return the quantity of a output product)

Initial stock	43
Inputs	Outputs	Total
0	10	33	43-10=33
15	0	48	33+15=48

So I want to create a variable to get values on total column (green values), I tried to do the following but this does not work:

$V{Stock_total}:

Initial value expression: $P{stock_initial}

Variable expression: $V{stock_input} >= 0 ? ($V{Stock_total} + $V{stock_input}) : ($V{Stock_total} - $V{stock_output})

Calculation: Nothing

The variable should calculate the initial value and add or subtract of input or output and display result, for the second line the result of the variable should be used to do a new calculation. I hope someone help me.

Thank you in advance.

[rajesh.sirsikar]

Hi Raul,

I have addressed your perticular problem in my blog http://www.rajeshsirsikar.com/creating-running-total-in-jaspersoft-studio/

Check it out !!

Thanks,

Rajesh Sirsikar

[rajesh.sirsikar]

Hi raul,

Check the answer below

 

[rajesh.sirsikar]

Thanks Raul. I am glad that it solved the issue.

[raul.mendez]

Thanks Rajesh, I did all displayed in your website and this work as expected, so this is solved.

Thank you for your help and great website.