Solved: How to rename a “New Formula Column”


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.

shampton82_0-1707936900492.png

 

Any thoughts?

 

Appreciate the help!

 

Steve



Source link

Leave a Comment