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
- :
- Sum only selected rows of a column

News

We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.

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

Highlighted

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

Aug 7, 2018 6:36 AM
(5585 views)

Is there an easy way to sum only the selected rows of a column and save the value to a global variable?

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

6 REPLIES 6

Highlighted
##

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

Re: Sum only selected rows of a column

Here is a simple script to do what you want

```
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt << set table variable( "my variable", Col Sum( If( Selected(), :height, . ) ) );
```

Jim

Highlighted
##

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

Re: Sum only selected rows of a column

How is this type of variable called? I can't call it using ::my variable

Highlighted
##

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

Re: Sum only selected rows of a column

@twillkickers,

They are referenced the same way you would reference a column

```
dt = Open( "$SAMPLE_DATA/big class.jmp" );
dt << Select Randomly(0.1);
dt << set table variable( "myvariable", Col Sum( If( Selected(), :height, . ) ) );
Print(:myvariable);
```

Best

Uday

Uday

Highlighted

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

Highlighted
##

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

Re: Sum only selected rows of a column

Thank you. This works for me. Is there a function similar to "set table variable" which sets the value as a global variable? (:: instead of :) I am having to take the table variable and save it as a global variable to do my calculations.

Highlighted
##

If you want to do this without using a script, first select the rows (using whatever method you want). Then, under Rows-Select-Name selection in column, you create a column of 0 and 1 that identifies the selected rows. Then create a new column using the Column Sum formula and put the newly created Named selection in column as the By variable. The result will show the sum for the selected and unselected rows.

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

Re: Sum only selected rows of a column