topic How to rename a "New Formula Column" in Discussions

How to rename a "New Formula Column"

shampton82 — Wed, 14 Feb 2024 18:57:16 GMT

Hey everyone,

I am trying to rename a " New Formula Column" that can have different amounts of columns that get summarized, the default column name out is always changing. However, I can't find a way to reference the column as when the column is made it is not selected.

The code to combine the columns is this:

dt3 <<
	New Formula Column(
		Operation( Category("combine"), "Sum" ),
		Columns(collistms1)
	);

However, using <<set name() or <<set selected doesn't work.

I was thinking I could loop through the Column list and add in the "+ " between each column name but that seems overly complicated.

Any thoughts?

Appreciate the help!

Steve

Re: How to rename a "New Formula Column"

mmarchandTSI — Wed, 14 Feb 2024 19:49:54 GMT

I'm unable to find a way to get the column reference when using << New Formula Column. You might have to resort to just using << New Column for this.

thiscol = Eval( Eval Expr( dt3 << New Column( "This One", Formula( Sum( Expr( collistms1 ) ) ) ) ) );

Re: How to rename a "New Formula Column"

jthi — Wed, 14 Feb 2024 19:57:17 GMT

To my knowledge you currently cannot get the reference easily. You can either use << New Column or check column names before you call New Formula Column and then again after you have called it. You can then get reference to the new columns based on the new column names