# Question about multi-row formula in Alteryx **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [November 7, 2024, 3:15am UTC](https://forum.knime.com/t/question-about-multi-row-formula-in-alteryx/84299 "2024-11-07T03:15:14Z")\ **Posts on this page:** 1\ **Showing post:** 6
**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\ **Post date:** [November 7, 2024, 7:59am UTC](https://forum.knime.com/t/question-about-multi-row-formula-in-alteryx/84299/6 "2024-11-07T07:59:16Z")
> [@MartinDDDD](#): > > There are some “hacky” ways I think that involve some Java Script that @takbb I think worked out Ah yes, thanks for the reminder @MartinDDDD🙂… the java snippet can be coded in such a way that it can remember the previous value but… > [@Column Expressions have Long Memories too!](https://forum.knime.com/t/column-expressions-have-long-memories-too/76048/1): > > The Column Expressions node, can remember a value from one row to the next if you use variables in a certain way. If you define variables, but only initialise their value when they are null, (which they are on the first row), but then don’t initialise them after that, then on subsequent rows, they retain their previous value. It’s actually relatively straightforward with Column Expressions, once you know the principle. (see above post) Granted, it’s still a bit “hacky”, lol. --- _[View the full topic](https://forum.knime.com/t/question-about-multi-row-formula-in-alteryx/84299)._