Hello, I am quite new to writing JMP scripts and primarily use "Edit Formula" for my work. I have been browsing solutions related to **Col Cumulative Sum** and could not find one for my specific problem. The simplified version of my data table is as follows.

**Row** | **Week** | **Col Cumulative Sum** | **My Wish** |

1 | 1 | 1 | 0 |

2 | 2 | 3 | 1 |

3 | 3 | 6 | 3 |

4 | 4 | 10 | 6 |

5 | 5 | 15 | 10 |

6 | 6 | 21 | 15 |

The formula below works if the current row value of "Week" is fixed or if I have two separate columns "Week" and "My Wish."

```
If( Row() != 1,
Lag( Col Cumulative Sum( :Week ), 1 ),
0
)
```

The issue is that the value of the previous row's "Week" is fixed but the current row's is not. And I only have one column "Week" to work with. I am developing a formula that simulates progression based on the previous simulation value. I am simulating the current row's "Week" value based on the previous row's.

Suppose I am working on Row 4 in the column "Week." I want to cumulatively sum all the previous "Week" values without calling the current "Week" value in the function. Otherwise, it creates an illegal reference or cycling problem in my case.

I tried using subscript instead of lag since the lag function calls the current row's "Week" value. It did not work.

```
If( Row() != 1,
Col Cumulative Sum( :Week )[Row() - 1],
0
)
```

I hope my explanation was clear enough. Thank you for your time and expertise in advance. I use JMP Pro 17.