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

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

FN — Sat, 10 Jun 2023 23:51:19 GMT

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.

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

txnelson — Tue, 19 Jul 2022 12:45:05 GMT

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

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

FN — Mon, 01 Aug 2022 09:25:22 GMT

Ticket created: Case TS-00009654

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

Audrey_Shull — Mon, 01 Aug 2022 20:41:06 GMT

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.