Why is there such unexpected re-calculation of columns without formulas?
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 tabl...