Subscribe Bookmark RSS Feed

Missing Values/Calculations

Steven_Moore

Super User

Joined:

Jun 4, 2014


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
Solution

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

3 REPLIES
kevin_c_anderso

Community Trekker

Joined:

Jun 5, 2014

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

ron_horne

Super User

Joined:

Jun 23, 2011

hi smoore2

try using the sum function instead of adding.

ron

Solution

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