Subscribe Bookmark RSS Feed

Cumulative count

asvp

Community Trekker

Joined:

Jun 23, 2011

All,

I have a table with column names Type, time and Errors, I want to create a new column
called CumErrors which will be cumulative errors for each type upto that time.

What is the best way to do this using JSL?

Regards,
-ASVP

Below is an example of what I am looking for:

Initial Table:

Type Time Errors
A 1 50
A 2 100
B 1 30
B 2 70
B 3 120

Need This table:

Type Time Errors CumErrors
A 1 50 50
A 2 100 150
B 1 30 30
B 2 70 100
B 3 120 220
2 REPLIES
ms

Super User

Joined:

Jun 23, 2011

One way to do it is to use a column formula (requires sorted table).
asvp

Community Trekker

Joined:

Jun 23, 2011

Thanks MS, this works.