9930_en-US

liliconcom

Setting "ignore errors" flag on a formula column<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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

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

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

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

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