Make calculation show on table summary?

eruck — Thu, 30 May 2024 14:59:42 GMT

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?

Re: Make calculation show on table summary?

txnelson — Thu, 30 May 2024 15:46:26 GMT

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))

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

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

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

topic Re: Make calculation show on table summary? in Discussions

Make calculation show on table summary?

Re: Make calculation show on table summary?