cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
UserID16644
Level V

Add values on same column

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