cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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