topic Re: Is there a way to reference a constant value in a data table without making a column for it? in Discussions

Is there a way to reference a constant value in a data table without making a column for it?

r_pearsall — Sat, 10 Jun 2023 23:21:22 GMT

I have a simple table with a column for mass of powder measured and another column for the resulting volume calculation. I could include an additional column for the known density, but I was wondering if there is a way to have a reference to a constant instead creating a column for it where all the values are identical.

Re: Is there a way to reference a constant value in a data table without making a column for it?

Dan_Obermiller — Tue, 27 Oct 2020 15:30:13 GMT

Make a table variable. Click the red triangle in the Table Panel of the data table and choose New Table Variable.

Re: Is there a way to reference a constant value in a data table without making a column for it?

txnelson — Tue, 27 Oct 2020 15:32:10 GMT

I hope I am understanding what you want. So lets say, you have a column A and a column B and you want to add them together and multiply by a constant value of 7. The formula for the new column would be

( :A + :B ) * 7;

Is this what you are asking for?

!Re: Is there a way to reference a constant value in a data table without making a column for it?

r_pearsall — Tue, 27 Oct 2020 15:38:46 GMT

Thanks Dan! This is perfect. I appreciate the tip.