topic Re: Referencing a Column by Column Number in Formula in Discussions

Referencing a Column by Column Number in Formula

pacificdune — Thu, 05 Apr 2018 21:40:15 GMT

I am creating a new column in my script and would like to populate the column by a simple formula. Instead of referencing by name, I would like to reference by column number in the formula because the column name will change depending on the work week, but it will always be the same column number.

dt<<New Column("New", formula(:Goal - :Column Name(36)));

The above expression does not work, but should give the gist of what I am trying to do.

Could not find any info on how to reference a column by number in the formula.

Re: Referencing a Column by Column Number in Formula

uday_guntupalli — Thu, 05 Apr 2018 21:48:11 GMT

@pacificdune ,

I believe you should be expressing it as :
As Column(Column Number) i.e. As Column(36) in your case for what you are trying to acheive

dt<<New Column("New", formula(:Goal - As Column(36)));

Re: Referencing a Column by Column Number in Formula

pacificdune — Thu, 05 Apr 2018 21:53:17 GMT

Tried it both with and without the colon, but unfortunaltely does not work either way.

dt<<New Column("New", formula(:Goal - :Column(36)));