Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Is there a way to make JMP evaluate column formulas starting at the bottom row and then working up (as opposed to the default top row first)?
The attached image is an example formula I made. For each row, it populates itself with the value in the "data" column, unless the "data" value is missing; in that case, it populates itself with the next value in the "formula" column (i.e. itself). Ideally, I would like the missing values currently shown in the column named "formula" to populate with "7", but because the formula evaluates starting at the top row, the next value in the "formula" column is missing, until it gets to row 7. If this formula evaluated starting at the bottom row and going up, then Lag(:"formula",-1) would never return any missing values. Thoughts?
NOTE: If I keep pressing the "Apply" button in the column formula GUI, eventually the "formula" column does fill in "7"s for rows 1-7 one at a time, but I can't actually do that in more complex applications where I don't know how many rows of empty data there are.