cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP 19 is here! See the new features at jmp.com/new.
  • Due to global connectivity issues impacting AWS Services, users may experience unexpected errors while attempting to authorize JMP. Please try again later or contact support@jmp.com to be notified once all issues are resolved.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
FN
FN
Level VI

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

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. 

Recommended Articles