topic Re: Using variables to create formula columns in Discussions

Using variables to create formula columns

rmeredith — Fri, 09 Jun 2023 18:04:05 GMT

For( i = 1, i <= N Items( allm ), i++,
	m = allm[i];
	name = "Peak Mass " || Char( m );
	del = Current Data Table() << delete columns( Char( name ) );
	(New Column( Char( name ), set formula( If( subtract(eval(m), 3) < :deltamass <= add(eval(m),3), :pctrelative, 0 ) ) ) ; 
	If( Contains( name, "Peak Mass 0" ),
		del
	) ; );
);

Help! I have tried like 5 things, and I can't get my variable to spit out it's numerical value into the column formula.

Re: Using variables to create formula columns

jthi — Thu, 28 Oct 2021 17:18:40 GMT

Eval(EvalExpr()) should do the trick

Re: Using variables to create formula columns

rmeredith — Thu, 28 Oct 2021 17:22:32 GMT

Just suck in where I currently have eval(m)? I just tried that and it is still just putting "Eval Expr(eval(m))" into the column function rather than the numerical value of m.

Re: Using variables to create formula columns

jthi — Thu, 28 Oct 2021 17:45:36 GMT

Most likely something like this:

	Eval(EvalExpr(New Column(Char(name), set formula(If(Subtract(Expr(m), 3) < :deltamass <= Add(Expr(m), 3), :pctrelative, 0))));

Wrap New Column() with Eval(EvalExpr()) and replace Eval with Expr() inside it.