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
- :
- adding formula to tabulate

- 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

Nov 10, 2019 4:17 AM
(1618 views)

Hi, it my first day on JMP, so basicly it is very simple question...

I would like to add a formula row to the tabel.

how can I do that?

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted

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

A formula can not be added directly to the display from the Tabulate Platform. What you need to do, is to go to the Red Triangle in the Tablulate Output, and select "Make into Data Table". Once the table is created, you can then add a formula to the table.

Jim

Highlighted

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

Orienting the table differently would make it easier to calculate your percent difference in the manner outlined by txnelson.

Using the data you provided, orient the table this way:

Now right-click and make into data table. Add a column for the formula that you have outlined (pin-countersink)/pin.

I'm sure there are other solutions, but this one does work.

Dan Obermiller

5 REPLIES 5

Highlighted

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

A formula can not be added directly to the display from the Tabulate Platform. What you need to do, is to go to the Red Triangle in the Tablulate Output, and select "Make into Data Table". Once the table is created, you can then add a formula to the table.

Jim

Highlighted
##

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

Re: adding formula to tabulate

Thanks

so what the best way to build a table like this (built with excel...) ?

the columns mean is the results ( of RP2% and Bearing) without separeted to the Variant (GF \ CF+GF)

attached the data file

Highlighted

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

Orienting the table differently would make it easier to calculate your percent difference in the manner outlined by txnelson.

Using the data you provided, orient the table this way:

Now right-click and make into data table. Add a column for the formula that you have outlined (pin-countersink)/pin.

I'm sure there are other solutions, but this one does work.

Dan Obermiller

Highlighted
##

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

Re: adding formula to tabulate

thanks!

And it is possible to add the data table to Jornal or other report?

And it is possible to add the data table to Jornal or other report?

Highlighted
##

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

Re: adding formula to tabulate

Yes, If there is an open journal you can click on the report or data table, and the use the key stroke, CNTL/J and it will be copied to the open journal.

All of this is documented in the Using JMP document, available under the Help pull down menu.

Jim