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

Question

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.

col_cumulative_sum_NA_error.jmp

Audrey_Shull · Answer

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.

FN · Answer

Ticket created: Case TS-00009654

txnelson · Answer

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