Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
tarpon17
Level I

How do I sum multiple columns using the formula window?

I have a table with 100 or more columns and would like to easily sum them in another column.  Best way to do so without making a formula A + B + C.....100 times

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
ms
Super User ms
Super User

Re: How do I sum multiple columns using the formula window?

If a dynamic formula is not crucial, the jsl script below should add a new static column with the row-wise sum of every numeric column in the data table.


dt = Current Data Table();

dt << New Column("sum", numeric, values(V Sum((dt << get as matrix)`)));


View solution in original post

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: How do I sum multiple columns using the formula window?

You can also do this within the formula editor using the Sum() function.

8819_Pasted_Image_5_21_15__5_13_PM.png

Fill in the argument for the function by clicking on the first column that you want to sum, and then shift-click on the last.

8820_Pasted_Image_5_21_15__5_07_PM.png

-Jeff

-Jeff

View solution in original post

2 REPLIES 2
Highlighted
ms
Super User ms
Super User

Re: How do I sum multiple columns using the formula window?

If a dynamic formula is not crucial, the jsl script below should add a new static column with the row-wise sum of every numeric column in the data table.


dt = Current Data Table();

dt << New Column("sum", numeric, values(V Sum((dt << get as matrix)`)));


View solution in original post

Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: How do I sum multiple columns using the formula window?

You can also do this within the formula editor using the Sum() function.

8819_Pasted_Image_5_21_15__5_13_PM.png

Fill in the argument for the function by clicking on the first column that you want to sum, and then shift-click on the last.

8820_Pasted_Image_5_21_15__5_07_PM.png

-Jeff

-Jeff

View solution in original post

Article Labels

    There are no labels assigned to this post.