I'm trying to create a table to show my analysis. This is what I'm trying:
quantityBulbsShipped = 0;
quantityLensesShipped = 0;
Current Data Table(dtBulbsOnly);
Summarize(quantityBulbsShipped = Sum(:qtyOrdered));
Current Data Table(dtLensesOnly);
Summarize(quantityLensesShipped = Sum(:qtyOrdered));
dtSolution = New Table("Percentage of bulbs shipped with lens",
New Column("Quantity bulbs shipped", "Continuous", Set Values(quantityBulbsShipped)),
New Column"Quantity Lenses Shipped", "Continuous", Set Values(quantityLensesShipped)),
New Column("% bulbs shipped with lenses", "Continuous", Set Values(quantityLensesShipped *100.0 / quantityBulbsShipped)));
ERROR: basically there is an issue with me using variables in the above Set Values() function inside the New Table() function.
Does anyone know how to get this to work or make a similarly simple output window?
Thank you a lot!