BookmarkSubscribe
Choose Language Hide Translation Bar
loysius
Community Trekker

JSL- New Table() assistance needed.

Hi there,

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",

Add Row(1),

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!

-Loysius

1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User ms
Super User

Re: JSL- New Table() assistance needed.

I think Set Values() requires a list (or matrix) argument.


Try:

Set Values( {quantityBulbsShipped} )


or

Set Values( list(quantityBulbsShipped) )


2 REPLIES 2
ms
Super User ms
Super User

Re: JSL- New Table() assistance needed.

I think Set Values() requires a list (or matrix) argument.


Try:

Set Values( {quantityBulbsShipped} )


or

Set Values( list(quantityBulbsShipped) )


loysius
Community Trekker

Re: JSL- New Table() assistance needed.

Thank you very much for the response. Yup, both of your solutions work. You're awesome