topic Re: Running total/Running Balance in App Development

Running total/Running Balance

john_tremper — Sat, 16 Nov 2024 21:35:29 GMT

Happy New Year!

I am trying to create a report that shows the running total/balance as shown below and not having much luck. A search on running total/balance will bring many results, not of which worked for me. I have tried setting up a field in the script and it still does not work. I have tried rangesum(), above(), rownno(total), and still unsuccessful. Does anyone have a fool proof way of getting what's shown below? It would be so easy to do in excel or SQL. Thanks in advance!

CusNo Customer Total Sales Running balance

1 ABC 5 5
2 DEF 7 12
3 GHI 12 24

Re: Running total/Running Balance

zzyjordan — Wed, 16 Jan 2019 22:51:28 GMT

Hi, John
Have you tried below expression?
RangeSum (above(sum([Total Sales]),0,RowNo()))

ZZ

Re: Running total/Running Balance

john_tremper — Thu, 17 Jan 2019 14:17:55 GMT

Hi ZZ, thanks for the response. I tried that solution and got the results shown in the attached file. The field I want to do the running balance on is: Total Balance. The Running Balance field is labled: ZZ. I also tried: RangeSum (above(sum([Total Balance]),0,RowNo()-1)) and got the results in the bottom portion of the report.

Thanks again!

Re: Running total/Running Balance

zzyjordan — Thu, 17 Jan 2019 23:11:01 GMT

Hi, John
Can you provide a sample qvf that reflect your issue?
ZZ