topic Re: decimal places in summary table in Discussions

decimal places in summary table

rahulsmils — Sat, 10 Jun 2023 23:13:31 GMT

Hi,

I am summarizing a jmp data table. In the summary table, I want the columns to have decimal places till 4.

However, jmp truncates everything after the decimal point.

When I try to retrieve the format for a column using jsl, it says the format is empty.

dt:Name("Median(A)")<< get property("Format");//Empty
dt:Name("Median(A)")<<Set property("Format", {"Scientific",12,2});//Scriptable[] but no change

Applying format through code doesn't work.

However, if I do this manually through column info dialogue box, by specifying decimal points, it does work.

I have like 50 columns and I wish to code this decimal format after selecting them.

Any help will be greatly appreciated.

Re: decimal places in summary table

txnelson — Tue, 13 Jun 2017 02:04:57 GMT

Get Property and Set Property are not the functions to use for the setting and retireving formats. The "Format" and "Get Format" messages are used.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
Show( dt:weight << get format );
dt:weight << Format( "Fixed Dec", 12, 6 );
Show( dt:weight << get format );

Re: decimal places in summary table

rahulsmils — Tue, 13 Jun 2017 03:14:38 GMT

Perfect, works! Thanks.

Re: decimal places in summary table

lazzybug — Thu, 11 May 2023 20:05:25 GMT

Hi @txnelson , can you tell how to apply the get format into a new column? for example

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dtformat= dt:weight << get format );
dt:weight << dtformat; (This is not working)
Show( dt:weight << get format );

Re: decimal places in summary table

txnelson — Thu, 11 May 2023 21:18:41 GMT

Here is my old school way of handling the issue. I am sure others may have a more straightforward way of handling it.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA\big class.jmp" );
dtformat= char(dt:weight << get format) ;
// Show the current format
Show( dt:weight << get format );
// Change the format and display the change
dt:weight << format("engineering");
Show( dt:weight << get format );
// Set the format back to the original format
eval(parse("dt:weight << " || dtformat || ";" )); 
Show( dt:weight << get format );