cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
eruck
Level I

Make calculation show on table summary?

Hi!

I am trying to get a column to show up on my table summary. This column would be the output of one of the columns IN the table summary divided by a constant. Is there a way to do that?

1 REPLY 1
txnelson
Super User

Re: Make calculation show on table summary?

Here is a simple example

names default to here(1);
dt =
// Open Data Table: Big Class.jmp
// → Data Table( "Big Class" )
Open( "$SAMPLE_DATA/Big Class.jmp" );

dtSumm = Data Table( "Big Class" ) << Summary(
	Mean( :height ),
	Freq( "None" ),
	Weight( "None" ),
	output table name( "Summary of Big Class" )
);

dtSumm << New column("Ratio", formula(:"Mean(height)"n/56))

txnelson_0-1717083578197.png

If you are using the Tabulate Platform, you will need to generate the calculated value in the data table, and then display it in the Tabulate output

txnelson_1-1717083682275.png

txnelson_3-1717083727403.png

or create a virtual column in Tabulate and use it in the display

txnelson_4-1717083917910.png

txnelson_6-1717083977035.png

 

 

 

 

If this is not how you are creating your summary table, please provide a sample of what you are doing

Jim

Recommended Articles