cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

Add values on same column

UserID16644
Level V

How can I add the N rows and store the sum on the next column?

UserID16644_0-1689064544741.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User


Re: Add values on same column

Create new column with a formula

Col Sum(:N Rows)

You can also right click on N Rows and use interactive formula builder

jthi_0-1689064947491.png

which will create same formula

jthi_1-1689064955559.png

 

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User


Re: Add values on same column

Create new column with a formula

Col Sum(:N Rows)

You can also right click on N Rows and use interactive formula builder

jthi_0-1689064947491.png

which will create same formula

jthi_1-1689064955559.png

 

 

-Jarmo
txnelson
Super User


Re: Add values on same column

Please see Jarmo's     @jthi  response for the solution.  I also suggest that you take the time to read through the Discovering JMP and Using JMP documents to add to your efficiency in using JMP.  One of the JMP features that is covered is the Formula Editor, which interactively presents all most all of the functions that can be used in the calculation of new formula columns.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     

Jim