Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Re: How to update column formulas

Topic Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Apr 20, 2018 1:42 PM
(3702 views)

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

2 ACCEPTED SOLUTIONS

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

`current data table() << Rerun Formulas.`

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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!

8 REPLIES 8

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

`current data table() << Rerun Formulas.`

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

@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.

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

@RobinFriedman thanks for the post. Formulas in data tables are not re-evaluated when a data table is opened. The thought is that the formula was evaluated before the data table was saved and nothing changed, so no need to re-evaluate.

Also, the data table doesn't treat formulas with Today() in them as special and constantly look at the date and re-evaluate.

So, in your case, if you want that column to be reevaluated when the data table is opened to reflect today's date, you'll need force it by adding a script named OnOpen to the data table. That script will be run whenever the data table is opened.

You can use the Eval Formula message to a column to force it to re-evaluate. So the OnOpen script would be:

`col<<Eval Formula`

If you want to evaluate all the formulas in the data table when it is opened you can use the Rerun Formulas message to the data table:

`dt<<Rerun Formulas`

-Jeff

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to update column formulas

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