topic Re: Setting "ignore errors" flag on a formula column in Discussions

Setting "ignore errors" flag on a formula column

David_Burnham — Tue, 18 Oct 2016 21:56:52 GMT

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

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

XanGregg — Wed, 05 Nov 2014 15:57:41 GMT

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 ) );

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

David_Burnham — Tue, 25 Nov 2014 00:17:22 GMT

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

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

ram — Sat, 09 Dec 2017 18:35:15 GMT

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