nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

adding formula to tabulate

TalDamri

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?

Accepted answers

txnelson

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.

Dan_Obermiller

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.

All comments

txnelson

TalDamri

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

test_12.11.2019.jmp

Dan_Obermiller

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.

TalDamri

thanks!

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