Page 1 of 1

values depending on the previous row

Posted: Wed Mar 18, 2015 2:11 pm
by willem.wijnant
I have a problem with StimulSoft:

I read the data from a database table; the debet and credit values. I want for each row compute the saldo. This depends on the saldo of the previous row, and the new debet and credit values:

saldo = saldo(previous row) + debet – credit;

Or : saldo = Sum(debet values until now) – sum (credit values until now)

How do I do this ?

Best Regards,

Willem Wijnant

Re: values depending on the previous row

Posted: Thu Mar 19, 2015 6:00 am
by HighAley
Hello, Willem.

Please, try to use expression like next

Code: Select all

SumRunning(debet - credit)
To give you more detailed answer we need to see your report template with sample data.

Thank you.

Re: values depending on the previous row

Posted: Thu Mar 19, 2015 2:14 pm
by willem.wijnant
It did solve the problem;

Thank you very much.

Willem

Re: values depending on the previous row

Posted: Thu Mar 19, 2015 4:21 pm
by Jan
Hello Willem,

Please contact us if you need any help!

Thank you.