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
- :
- Setting "ignore errors" flag on a formula column

Topic Options

- 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

Setting "ignore errors" flag on a formula column

Oct 25, 2014 3:33 AM
(1950 views)

I have a formula column (confidence interval from the nonlinear platform) that sometimes generates an error during evaluation:

This error can not be captured in a Try() block.

My work around is to set the Suppress Eval flag and manually evaluate the formula one row at a time but I would prefer to be able to set the "Ignore Error" flag on the column to suppress repeated error messages that occur.

I've not found a way to set this in JSL. Any ideas?

Dave

-Dave

3 REPLIES

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

Re: Setting "ignore errors" flag on a formula column

Nov 5, 2014 7:57 AM
(1691 views)
| Posted in reply to message from David_Burnham 10/25/2014 06:33 AM

You've probably already tried this, but just in case: maybe you can pre-catch the error, such as

If( not symmetric(x), ., rest of formula(x))

If it's any consolation, the JMP 12 beta will turn on Ignore Errors automatically when you set a problem formula via script. I tried:

Column**(** "X" **)** << **Set Formula****(** If**(** Random Uniform**(** **0**, **1** **)** < **0.5**, Foo**()**, **1** **)** **)**;

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

Re: Setting "ignore errors" flag on a formula column

Thanks Xan

The problem is that I am saving the formula from the nonlinear platform and the error gets raised during the save message - so I don't have time to inspect the formula to test for an error condition. I'll take another look at how it behaves in JMP 12 Beta but from memory I wasn't able to "silence" the errors.

Dave

-Dave

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

Re: Setting "ignore errors" flag on a formula column

Hi Gregg,

Could you see if you have ans to below exceptions for formula errors:

1. if it is not possible to pre catch the error. e.g my formula is a string and i will not know error untill i parse and eval the formula string.

2. when we run formula via button it does not send error to log instead it pops a window. And formula errors becomes monsters when you are creating 1000s formula columns and you get bombarded with pop error windows like spam.

Thanks for your help