Here is the JMP Data Table: Among the variables, Total Dead was easily calculated by using the following formula.
Col Cumulative Sum(:Dead)
Total Dead can be easily obtained by using the above formula because it is a cumulative sum from the first row sequentially.
In the case of Total Alive, however, the cumulative sum must be obtained from the 9th row in reverse order. That is, the ninth row is the value of the ninth row, the eighth row is the cumulative sum of the ninth and eighth rows, the seventh row is the cumulative sum of the ninth row, the eighth row, the seventh row, The first row is the cumulative sum of the rows from the 9th row to the first row.
What JSL or formula can be used?
JMP Data Table is also attached.
Thank you in advance.
dt = Current Data Table();
data = :Alive << get values;
dataReordered = data [N Row()::1];
newData = Cumulative Sum( dataReordered );
newDataReordered = newData [N Row()::1];
:Total Alive << values(newDataReordered);
// or a bit shorter
dt = Current Data Table();
data = :Alive << get values;
CumSumReordered = Cumulative Sum(data [N Row()::1]);
:Total Alive << values(CumSumReordered[N Row()::1]);
This should do the job, however there might be an easier way.
