topic Re: How to sum the values in an unnamed column in Discussions

How to sum the values in an unnamed column

wyler00 — Thu, 04 Apr 2024 16:42:50 GMT

Hi,

I have a DOE setup where the names of the columns change. Is there a way to sum the values in column 1 and put them in Column "Total Volume" row 1, then sum column 2 and put them in "Total volume" row 2, etc? Thanks.

Re: How to sum the values in an unnamed column

jthi — Thu, 04 Apr 2024 17:03:57 GMT

It is possible but it isn't really something you should do with JMP as JMP table isn't a spreadsheet( ). Below is example formula to give an idea how it could be done

If(
	Row() == 1, Col Sum(Column(1)),
	Row() == 2, Col Sum(Column(2)),
	.
)

Re: How to sum the values in an unnamed column

dlehman1 — Thu, 04 Apr 2024 17:05:35 GMT

I think I may be misunderstanding what you want. But it sounds like using Table-Summary and asking for the sum of the relevant columns will give you what you want. You can then make it into a data table. If you need to have it placed in the original table with each row a different sum of columns, then you probably need to do something else.

Re: How to sum the values in an unnamed column

wyler00 — Thu, 04 Apr 2024 17:17:30 GMT

Thank you this answered my question. And thanks for the link to JMP is not a spreadsheet. I've never seen this before and I do try to use JMP as a spreadsheet too often