I'm trying to create a bunch of new columns with formulas based on existing columns. New column statement is inside For loop and I want to use strings from a list as part column names.
My columns are from the table constructed by Summary function, thus they have "," in the names
InColumn = "qty_in, "||steps[step#];
OutColumn = "qty_out, "||steps[step#];
dt << New Column( Eval("% "||steps[step#]),
numeric,
continuous,
formula( Name(OutColumn) / Name(InColumn) * 100, 1));
steps is a list of strings {"a", "b", "c"} and step# is an integer of For cycle.
What I can not figure out is how to make my OutColumn and InColumn a "quoted string" so formula will work. I've tried Eval and Parse and As Name - nothing worked so far.
Any help will be greatly appreciated.