cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Steven_Moore
Level VI

Missing Values/Calculations


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
mwechtal
Level III

Re: Missing Values/Calculations

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

View solution in original post

3 REPLIES 3
Kevin_Anderson
Level VI

Re: Missing Values/Calculations

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

ron_horne
Super User (Alumni)

Re: Missing Values/Calculations

hi smoore2

try using the sum function instead of adding.

ron

mwechtal
Level III

Re: Missing Values/Calculations

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