Cannot perform Boolean logic using jmp script on table formula

dsoltz1

Hi,

I am trying to run a simple script that will select and then hide and exclude points that are greater than 100 mm in radial distance from the center. 

 

To simplify debugging, I split this into two scripts: the first one generates a column with the radial distance Radial = (x^2 + y^2)^(1/2) formula and the second evaluates this formula, selecting and hiding rows where Radial > 100.

 

Unfortunately this does not work. For some very strange reason, evaluation only works on this formula up to a certain value. Radial > (anything over 30) selects all rows.

 

I can see two solutions:

1) Write values into the Radial column, not the formula itself. (Values are evaluated properly, the formula is not). Not sure how to do this.

2) Understand and correct the problem so that the formula can be evaluated against a value greater than 30.

 

Either a scripting answer or interactive explanation would be acceptable. Would like to resolve this problem and learn from it.

Thanks!

Dave

 

// script for creating the Radial column<BR />dt1 = Current Data Table ();
dt1 << New Column( "Radial", Formula ((X coordinate^2 + Y coordinate^2)^(1/2)));<BR /><BR />//&nbsp;script&nbsp;for&nbsp;evaluating&nbsp;the&nbsp;Radial&nbsp;formula<BR />dt =Current Data Table();<BR />dt << Clear Row States; <BR />dt << Select where(Radial < 100);<BR />dt << hide and exclude;<BR />

dsoltz1

Thanks for replying Jeff.

 

Pasting the last line of your script into mine did not resolve the problem. However I was able to come with a solution by changing the name of the column to "Radial 1" and adding a line with Eval Formula at the end. Not sure why this works. The data table is about 1,300 rows with 15 columns, each number has a width of 10 to 12.

 

The following two scripts work. Am pasting them in their entirety. The other lines evaluate pit depth and distribution.

Any idea why the modifications worked? I have been at this for most of the day.

Script 1: Create "Pits Only" and "Radial 1" columns

dt1 = Current Data Table ();
dt1 << Clear Row States;
dt1 << New Column( "Pits Only", Formula (If( :Name( "Height (mm)" ) <= 0,	:Name( "Height (mm)"), 0 )) );
dt1 << New Column( "Radial 1", Formula ((X coordinate^2 + Y coordinate^2)^(1/2)));
dt1 << Eval Formula;
obj = dt1 << Distribution( Column( :Pits Only), Horizontal Layout( 1 ), Count Axis);

Script 2: Hide and Exclude rows with Pits Only > 10 or Radial 1 > 100 or Radial 1 < 30

dt =Current Data Table();
dt << Clear Row States; 
	win = New Window( "Feature Depth" , <<Modal, <<Return Result,
	Text Box( "Input Min Feature Depth" ),
	minfeat_abs = Number Edit Box( 4 ), 
 );

 mf = win["minfeat_abs"];

 mf = -mf/1000;

// show (mf);

dt << Select where((Radial 1> 100) | (Radial 1< 30) | (Pits Only > mf));
dt << hide and exclude;