762041_en-US

liliconcom

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?

Data Blending and CleanupQuality and Process EngineeringWindowsRe: 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))

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