cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-6766%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E7%B4%AF%E7%A9%8D%E5%90%88%E8%A8%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6766%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3EJMP9%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E7%B4%AF%E7%A9%8D%E5%90%88%E8%A8%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%99%E3%81%8B%3F%E3%81%A4%E3%81%BE%E3%82%8A%E3%80%81SUM%20%E3%81%A8%E3%81%84%E3%81%86%E6%96%B0%E3%81%97%E3%81%84%E5%88%97%E3%81%AB%20COUNT%20%E5%88%97%E3%81%AE%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E8%93%84%E7%A9%8D%E3%81%97%E3%81%9F%E3%81%84%E3%81%AE%E3%81%A7%E3%81%99%E3%81%8C%E3%80%81%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88%E3%82%B5%E3%83%A0%3C%2FP%3E%3CP%3E0%200%3C%2FP%3E%3CP%3E0%200%3C%2FP%3E%3CP%3E1%201%3C%2FP%3E%3CP%3E1%202%3C%2FP%3E%3CP%3E0%202%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E3%81%94%E5%8D%94%E5%8A%9B%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%E3%81%94%E3%81%96%E3%81%84%E3%81%BE%E3%81%97%E3%81%9F%EF%BC%81%EF%BC%81%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-46273%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B4%AF%E7%A9%8D%E5%90%88%E8%A8%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-46273%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%2013.2.1%20%E3%81%AE%E6%95%B0%E5%BC%8F%E4%BB%95%E6%A7%98%E3%81%AF%E6%AC%A1%E3%81%AE%E3%81%A8%E3%81%8A%E3%82%8A%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ECol%20Cumulative%20Sum(%20%3Aweight%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-46269%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B4%AF%E7%A9%8D%E5%90%88%E8%A8%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-46269%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E3%82%84%E3%81%82%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%B7%BB%E4%BB%98%E3%81%AE%E5%BC%8F%E3%81%8C%E3%82%8F%E3%81%8B%E3%82%8A%E3%81%AB%E3%81%8F%E3%81%84%E3%81%A7%E3%81%99%E3%80%82%20%E3%81%93%E3%81%AE%E5%BC%8F%E3%82%92%E4%BD%BF%E3%81%A3%E3%81%A6%E3%81%A9%E3%81%AE%E3%82%88%E3%81%86%E3%81%AA%E8%A8%88%E7%AE%97%E3%81%8C%E8%A1%8C%E3%82%8F%E3%82%8C%E3%82%8B%E3%81%AE%E3%81%8B%E3%80%81%E4%BE%8B%E3%82%92%E6%8C%99%E3%81%92%E3%81%A6%E8%AA%AC%E6%98%8E%E3%81%97%E3%81%A6%E3%81%84%E3%81%9F%E3%81%A0%E3%81%91%E3%81%BE%E3%81%99%E3%81%8B%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6767%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E7%B4%AF%E7%A9%8D%E5%90%88%E8%A8%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6767%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%223586_Screen%20Shot%202013-05-20%20at%208.52.47%20AM.png%22%20style%3D%22width%3A%20162px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%223586_Screen%20Shot%202013-05-20%20at%208.52.47%20AM.png%22%20style%3D%22width%3A%20162px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%223586_Screen%20Shot%202013-05-20%20at%208.52.47%20AM.png%22%20style%3D%22width%3A%20162px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F149iD612EACA568DD89D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%223586_Screen%20Shot%202013-05-20%20at%208.52.47%20AM.png%22%20alt%3D%223586_Screen%20Shot%202013-05-20%20at%208.52.47%20AM.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%E5%88%97%E3%81%AE%E6%95%B0%E5%BC%8F%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%80%81%5B%E7%B5%B1%E8%A8%88%5D%20%26gt%3B%20%5B%E5%90%88%E8%A8%88%5D%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E4%B8%8A%E8%A8%98%E3%81%AE%E5%BC%8F%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%97%E3%80%81%E4%B8%8B%E4%BB%98%E3%81%8D%E6%96%87%E5%AD%97%20i%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E7%9B%AE%E7%9A%84%E3%81%AE%E8%A1%8C%E3%81%A8%E5%88%97%E3%82%92%E5%85%A5%E5%8A%9B%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
zoulanlan
Level I

how to get cumulative sum data?

How do I use JMP9 to get cumulative sum data?  That is, I want to accumulate data from column COUNT in a new column called SUM,

COUNT      SUM

0                0

0                0

1                1

1                2

0                2

Thank you for your help!!

1 ACCEPTED SOLUTION

Accepted Solutions
louv
Staff (Retired)

Re: how to get cumulative sum data?

3586_Screen Shot 2013-05-20 at 8.52.47 AM.png

Use the Column Formula and enter the above expression using the Statistical>Summation, Row and Column of interest with subscript i

View solution in original post

3 REPLIES 3
louv
Staff (Retired)

Re: how to get cumulative sum data?

3586_Screen Shot 2013-05-20 at 8.52.47 AM.png

Use the Column Formula and enter the above expression using the Statistical>Summation, Row and Column of interest with subscript i

nac
nac
Level III

Re: how to get cumulative sum data?

Hi

 

I have difficulty to understand at the attached formula. Could you please explain what calculation is done by using this formula with an example? 

txnelson
Super User

Re: how to get cumulative sum data?

The formula specification for JMP 13.2.1 is:

Col Cumulative Sum( :weight )
Jim

Recommended Articles