running cumulative sum

[geeksqaud]

Hi,

i am trying to a get a running sum of points for an employee . Tried different ways but couldn't get to the solution

EmployeeNumber	Points	Employee Name	start	end	Calculated Column based on Column B- points
5925801	2	John	9/11/2022	9/13/2022	10
5925801	2	John	3/6/2022	3/6/2022	8
5925801	2	John	1/9/2022	1/11/2022	6
5925801	2	John	12/25/2021	12/26/2021	4
5925801	1	John	12/1/2021	12/4/2021	2
5925801	1	John	10/29/2021	10/30/2021	1

Appreciate your help with this.

Thanks in Advance

[IraWatt · Accepted solution]

Hey @geeksqaud,

Here is one way to do this:

First thing to point out is there is a running total tool which you can use to get a running total grouped by each employee (see above). The tool works top down so before it I ordered the data ascending by end date. I also had to convert your text date to a date data type. 

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com