topic Re: sum of columns is not work because of empty data in Discussions

sum of columns is not work because of empty data

nac — Sat, 10 Jun 2023 23:27:47 GMT

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.

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

jthi — Thu, 25 Mar 2021 08:30:43 GMT

Have you tried using Sum formula:

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

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

txnelson — Thu, 25 Mar 2021 08:31:55 GMT

Use

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

The Sum() function ignores missing values