Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
May be this
RangeSum(Above(Sum(StaffOnsite), 0, RowNo()))
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 |
Try this
RangeSum(Above(TOTAL Sum(StaffOnsite), 0, RowNo(TOTAL)))
I ended up using
RangeSum(Above(TOTAL Sum(StaffOnsite), 0, arrival_order)) and that worked.. Thank you