unable to eval a formula in a table

Question

Hi all ,

I am trying to eval a expression in a formula but it seems to have error, can someone help me ?

My formula is below:

dtmaster << New Column("_SBL",
			Numeric,
			Formula(
				 (Match( :Selected_Sigma,
					"Flag_3Sigma",Eval expr(((column(8)- column(6)) / 3) * 3 + column(6)),
					"Flag_4Sigma",Eval expr( ((column(8)- column(6)) / 3) * 4 + column(6)),
					"Flag_5Sigma",Eval expr(((column(8)- column(6)) / 3) * 5 + column(6)),
					"Flag_6Sigma",Eval expr(((column(8)- column(6)) / 3) * 6 + column(6))
				))) 
			,
			Format( "Percent", 12, 2 )
		)

Craige_Hales · Answer

dt = Open( "$sample_data/big class.jmp" );

dt << New Column( "H_OR_W",
	Numeric,
	Formula(
		(Match( :sex,
			"F", height, // height
			"M",
				Column( 5 )[] // weight
		))
	),
	Format( "Percent", 12, 2 )
);

if you use an explicit column name, like height, above, then JMP knows to index with the current row. If you use the column function to specify the column, you still need to index into the column. You can use the empty subscript shown above to tell JMP to use the current row. See the weight example above.

kuannygoh · Answer

Hi, the error shown is as attached in image

kuannygoh · Answer

I am trying to match the column of selected sigma with formula.