nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

15189_en-US

liliconcom

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?

Re: Missing Values/Calculations

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

Re: Missing Values/Calculations

hi smoore2

try using the sum function instead of adding.

ron

Re: Missing Values/Calculations

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

Comments

There are no comments yet