topic Re: Need help with running sum in App Development

Need help with running sum

Anonymous — Wed, 24 Jan 2018 17:31:30 GMT

Hey guys,

I am having issues with this I need to be able to do this on a pivot chart as well as backend script . The last column adds the staff on site . and sorts it by Arrival order and groups by id. Any help would be appreciated. Thank you so much!

ID	Arrival_Order	StaffOnsite	Running Sum needed Column
10-0000313	4	3	3
10-0000313	5	3	6
10-0000401	3	3	3
10-0000401	4	3	6
10-2093202	1	4	4
10-2093202	2	6	10
10-2093202	4	9	19
10-2093202	5	2	21

Re: Need help with running sum

sunny_talwar — Wed, 24 Jan 2018 19:02:15 GMT

May be this

RangeSum(Above(Sum(StaffOnsite), 0, RowNo()))

Re: Need help with running sum

Anonymous — Fri, 26 Jan 2018 19:16:21 GMT

Thanks, however when I add a column to this it stops the running total. is there a way I can use the rangesum in script and pull from there? i need it to reset when inci_no changes and arrival order rolls back to 1.

ID	unit	Arrival_Order	StaffOnsite	Running Sum needed Column
10-0000313	2w	4	3	3
10-0000313	e31	5	3	6
10-0000401	d2	3	3	3
10-0000401	e2	4	3	6
10-2093202	41	1	4	4
10-2093202	24	2	6	10
10-2093202	xw2	4	9	19
10-2093202	xss	5	2	21

Re: Need help with running sum

sunny_talwar — Fri, 26 Jan 2018 20:18:40 GMT

Try this

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, RowNo(TOTAL)))

Re: Need help with running sum

Anonymous — Fri, 26 Jan 2018 20:30:57 GMT

I ended up using

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, arrival_order)) and that worked.. Thank you