nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to update column formulas

bio_grad

Hello,

I am working with files with ~300K rows with 85 columns (quite a few formula columns). I am wondering if there is a button or JSL command that can prompt all columns and their dependents to update.

I am finding that some columns are not automatically updating.

Thank you

Accepted answers

txnelson

This statement will rerun all of the formulas. You could add it to the tool bar if you want

current data table() << Rerun Formulas.

markschahl

Click on the red triangle to the left of the data table name (top left of the script area, just below toolbar).

Bottom of the dropdown that will appear: Rerun Formulas

Thanks to Jerry Cooper for teaching me that one!

All comments

txnelson

This statement will rerun all of the formulas. You could add it to the tool bar if you want

current data table() << Rerun Formulas.

bio_grad

Thank you!

Jeff_Perkinson

@txnelson gave you a good solution but I'm concerned about the circumstances under which the formulas are not being re-evaluated automatically.

@bio_grad, can you send any details about this to support@jmp.com? If there's an issue that needs to be addressed we want to look at it.

Thanks.

markschahl

Click on the red triangle to the left of the data table name (top left of the script area, just below toolbar).

Bottom of the dropdown that will appear: Rerun Formulas

Thanks to Jerry Cooper for teaching me that one!

bio_grad

Awesome! I didn't even think to check. Thanks

bio_grad

Hi Jeff, I can't seem to replicate the issue now. What I think might have happened is that I accidentally clicked 'cancel' instead of 'apply' after modifying a formula without realizing.

RobinFriedman

Jeff, I have seen this recently (JMP 14.3.0) on formulas which use the Date Difference function to calculate the time between a fixed date (column in the data table) and the current date (today()). An example file is attached. It was created today (6/14/19) and is fine, but if checked tomorrow or later the formulas will not properly evaluate until refreshed.

sample file.jmp