371252_en-US

liliconcom

sum of columns is not work because of empty data

Hi,

 

I try to sum Column 1+Column 2+Column 3 in a seperate column by using formula option of jmp. But sometimes some rows results are empty. due to that formula editor is not calculate the result. Could you please help for it?

 

Please find enclosed jmp file as an example to explain my issue.

Data TableRe: sum of columns is not work because of empty data

Have you tried using Sum formula:

Sum(:Column 1, :Column 2, :Column 3)

Re: sum of columns is not work because of empty data

Use

sum( :column 1, column 2, :column 3);

The Sum() function ignores missing values