topic Re: How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table in Discussions

How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table

Rily_Maya — Fri, 06 Jun 2025 01:14:19 GMT

How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table

For example, in Table 4.5.jmp:

let A=4.54766666666667 + 0.0566666666666667 * :Speed + -0.605 * :Pressure,

let B=4.44891666666667 + 0.0766666666666667 * :Speed + -0.605 * :Pressure，

let C=6.66193304843305 + -0.00789173789173778 * :Speed + -0.605 * :Pressure.

Re: How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table

jthi — Fri, 06 Jun 2025 04:17:20 GMT

You can use table variables or create columns with those values and use them.

Re: How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table

Rily_Maya — Fri, 06 Jun 2025 06:53:31 GMT

As shown in the figure, there is an error.
Why?

Re: How to Configure Variables Only Once for Application Across Multiple Formulas Within a Single Data Table

jthi — Fri, 06 Jun 2025 07:10:19 GMT

If you wish to repeat a formula, create a formula column and refer to that. If you wish to repeat a constant create table variable (or column with the value). To use table variable in a formula you reference it like you would a column so in this case :A