cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
FN
FN
Level VI

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

Created: Jul 19, 2022 08:13 AM  |  Last Modified: Jun 10, 2023 4:51 PM (774 views)

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

 

col_cumulative_sum_NA_error.jmp
3 REPLIES 3
txnelson
Super User txnelson
Super User

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

Jul 19, 2022 08:45 AM (768 views)  |  Posted in reply to message from FN 07-19-2022

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

Aug 1, 2022 05:25 AM (736 views)  |  Posted in reply to message from txnelson 07-19-2022
Ticket created: Case TS-00009654
0 Kudos
Audrey_Shull
Staff Audrey_Shull
Staff

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

Aug 1, 2022 04:41 PM (726 views)  |  Posted in reply to message from FN 07-19-2022

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. 

0 Kudos