topic Re: adding formula to tabulate in Discussions

adding formula to tabulate

TalDamri — Sun, 10 Nov 2019 12:17:07 GMT

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?

Re: adding formula to tabulate

txnelson — Sun, 10 Nov 2019 14:35:04 GMT

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.

Re: adding formula to tabulate

TalDamri — Tue, 12 Nov 2019 09:33:01 GMT

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

Re: adding formula to tabulate

Dan_Obermiller — Tue, 12 Nov 2019 15:31:58 GMT

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.

Re: adding formula to tabulate

TalDamri — Wed, 13 Nov 2019 05:15:24 GMT

thanks!

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

Re: adding formula to tabulate

txnelson — Wed, 13 Nov 2019 05:48:06 GMT

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.