turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Accumulate column data

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 17, 2009 12:14 PM
(907 views)

tair chilling degree

5 5

7 5

5 10

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 17, 2009 1:12 PM
(646 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 18, 2009 11:00 AM
(646 views)

1. Create a new column. In this example, I call it "total".

2. Put the following formula in the new column:

(ignore this line)

The formula takes the value of tair in the current row, and adds it to the previous value of total, thus creating a cumulative sum.

If you only want to accumulate the values if they are greater than or equal to 5, then use the formula:

(ignore this line)

The formula looks at the current value of tair, and if it is less than 5, instead of adding tair, it adds 0.