I often use JMP to prototype data pipelines, calculating column values in one table, then querying data into another table based on calculation results. I noticed a behaviour that looks to me very strange and counterintuitive. Say, I have a table with three columns:

The second and the third columns are calculated as Lag ( :Column 1 ) and Col Sum ( :Column 1 ).
Now I query the rows into a new table where :Column 1 > 2. The result is:

":Lag of Column 1" and ":Column 1 Sum" get re-calculated, since the table inherited the formulas. This is understandable.
But what if I delete the formulas and update the table? Then, since I do not have formulas and I do not re-calculate values in the destination table, I will see the data as it is in the the source table, right? Guess what, wrong! Nothing changes. I still see null, 3 and 7, 7 not 2, 3 and 10, 10.
Is this a defect? Or is this as expected? How can this be explained?
Thanks!