JSL to create a column that is a cumulative sum based on previous row of other columns
Sep 7, 2020 7:41 AM(131 views)
I am using JMP Pro 12.
I need help to create a new column ('cum_Qty') in JSL that will be an ongoing sum of the previous rows value in 'Qty'column until meet => 500. If the row qty is => 500 in , the value will update as it in the 'cum_Qty'.
In workweek 2, the qty is 633 (> 500) in 'Qty'column, this value is updated as 633 in 'çum_Qty' column.
In workweek 3, the qty is 185 (< 500), it sums 185 + 633 = 818, this value is updated in 'çum_Qty' column.
In workweek 4, the qty is 130 (<500), it sums 130 + 185 + 633 = 948, this value is updated in 'çum_Qty' column.