This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
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: 
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 07:51 PM (403 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 (397 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 (365 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 (355 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