Trying to create a column and fill it with a formula but I get an error.

[#1]

View more...

Hi, I can make the script to fill the new column created.

This is the error I get:
 Has anyone an idea of whats wrong here?


Formula Interrupted
Cannot convert argument to a number [or matrix] at row 1 in access or evaluation of 'Subtract' , Column( j ) - /*###*/Column( j + 1 ) /*###*/
Formula evaluation errors have been ignored

For (j=3, j<=10, j=j+2,
	
	ColLen=Length(Char(Column name (j)));
	ColName=Left (Char(Column Name(j)),ColLen -5);
	NewCol=Substr(ColName,6);
	
	New Column(
		"Delta: "||NewCol,
		Numeric,	
		Formula (
			(Column (j)- Column(j+1))
		)
	)
);

[#2]

Just As Column() instead of column worked!

[#3]

@CrownofTears, Based on your original JSL:

For( j = 3, j <= 10, j = j + 2, 
	
	ColLen = Length( Char( Column Name( j ) ) );
	ColName = Left( Char( Column Name( j ) ), ColLen - 5 );
	NewCol = Substr( ColName, 6 );
	
	Eval(
		Eval Expr(
			New Column( "Delta: " || NewCol,
				Numeric,
				Formula( (As Column( Expr( Column Name( j ) ) ) - As Column( Expr( Column Name( j + 1 ) ) )) )
			)
		)
	);
);

I like the clean As Column("column name") functions, and it's not ugly like my Eval( Parse(...) ) solution.

[#4]

Just As Column() instead of column worked!

[#5]

Seems to work "once" (the values are OK)  - but (at least for my test case) variant #1 reports an error with the formula when you open it afterwards:

Variant # 6 seems to solve this issue:

but it will definitely fail once Jmp is closed and forgets what dt means ....