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.
See how to use JMP Live to centralize and share reports within groups. Webinar with Q&A April 4, 2pm ET.
Choose Language Hide Translation Bar
View Original Published Thread

Col Cumulative Sum by group increases counter if first row is missing or empty

FN
FN
Level VI

I found this behavior while using the Col Cumulative Sum() as a way to create a counter.

 

If the group column has a missing value in the first row, the groups are completely ignored, see the last column below.

 

FN_0-1658232575726.png

 

3 REPLIES 3
txnelson
Super User


Re: Col Cumulative Sum by group increases counter if first row is missing or empty

I replicated you findings.  There also seems to be a relationship between missing values and the starting value of zero.  Put a valid, but non zero value in row one and different results are shown.

 

Please turn your findings into the JMP Support team

     support@jmp.com

Jim
FN
FN
Level VI


Re: Col Cumulative Sum by group increases counter if first row is missing or empty

Ticket created: Case TS-00009654


Re: Col Cumulative Sum by group increases counter if first row is missing or empty

Thanks so much for reporting this - we have replicated the issue in the Development team and it is on track to be addressed in a future version of JMP.