Changing the format of a variable in a data table

[#1]

Hi,

i have the following syntax:

dt2<< Summary(
	Group( :Sample ),
	Mean( :dilution factor, :l10t ),
	Freq( "None" ),
	Weight( "None" ),
	Output Table( "log10t" ),
	Std Err( :l10t ),
	Link to original data table(0)
);

Loq = Data Table( "log10t" );


Loq << column(:Mean(l10t)) <<Format( "Fixed Dec", 12, 4 );

Loq << column(:Name ("Mean(l10t)")) << Format( "Fixed Dec", 12, 4 );  

Column(Loq,:Mean(l10t)) << Set Format ( "Fixed Dec", 12, 4 );

so l get a data table using the above syntax, however, the variable Mean(l10t) it produces in the table has 10 decimal places, the next three lines of code are trying to re format to a fixed decimal place of 4, none has worked, could anyone please advise why??

Also when i work with variables in JMP sometimes i can use just :variable name to use the variable, quite often this wont work and i have to use :Name("Variable Name"), why??

Thanks

[#2 · Accepted solution]

Either of these syntax forms will work

loq:Name("Mean(l10t)") << Format( "Fixed Dec", 14, 4 );

column( loq, "Mean(l10t)" ) << Format( "Fixed Dec", 14, 4 );

[#3]

thanks Jim, i had tried several bits of code, that worked a treat