turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- JSL- New Table() assistance needed.

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 5, 2015 4:28 PM
(1247 views)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 6, 2015 12:53 PM
(2250 views)

Solution

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

Try:

Set Values**(** **{**quantityBulbsShipped**}** **)**

or

Set Values**(** list**(**quantityBulbsShipped**)** **)**

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 6, 2015 12:53 PM
(2251 views)

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

Try:

Set Values**(** **{**quantityBulbsShipped**}** **)**

or

Set Values**(** list**(**quantityBulbsShipped**)** **)**

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 6, 2015 1:40 PM
(1125 views)

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