topic Re: How to use a column reference inside a formula inside of a column formula? in Discussions

How to use a column reference inside a formula inside of a column formula?

rcast15 — Tue, 19 Aug 2025 16:40:12 GMT

If I have a column reference stored as a variable, call it clbColumn, how can I use this column for a given data table inside a function which is inside of a formula for a new column.

<JSL>

dt << New Column("Actual Timepoint", Numeric, Continuous, Formula(Date Difference(clbColumn, clbColumn2 "day") / 30.417));

<JSL>

Re: How to use a column reference inside a formula inside of a column formula?

jthi — Tue, 19 Aug 2025 16:48:00 GMT

You will have to evaluate the references. Here is one example

Names Default To Here(1); 

dt = open("$SAMPLE_DATA/Big Class.jmp");

col1 = "height";
col2 = "weight";

Eval(Substitute(
	Expr(dt << New Column("Mult", Numeric, Continuous, Formula(
		_col1_ * _col2_
	))),
	Expr(_col1_), Name Expr(AsColumn(dt, col1)),
	Expr(_col2_), Name Expr(AsColumn(dt, col2)),
));