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
- :
- Missing Values/Calculations

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

Nov 5, 2015 5:18 AM
(2265 views)

I have a data table in which I want to add the row values of four columns into a fifth column. However, I have missing values in all four original columns and that is OK, but when I apply the formula to add the four columns, all I get is a column of missing values because JMP will not add three values and a missing value. What can I do to remedy this situation?

Steve

1 ACCEPTED SOLUTION

Accepted Solutions

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

Nov 5, 2015 6:52 AM
(4144 views)

Solution

If you use the SUM function instead of the + operator, it should add the non-missing values.

3 REPLIES

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

Nov 5, 2015 6:36 AM
(2072 views)

Instead of using the + operator, try the Sum(:Col1, :Col2, :Col3) function.

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

Nov 5, 2015 6:52 AM
(2072 views)

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

Nov 5, 2015 6:52 AM
(4145 views)

If you use the SUM function instead of the + operator, it should add the non-missing values.