cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
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