cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
natalie_
Level V

Numeric Formats in Tabulate Platform

Hi all,

I am trying to change the numeric formats in the tabulate platform, and I can't get it to do scientific notation or engineering SI.  Is it not possible?  I would also really like to reduce the number of significant digits.  I am able to change the number of significant digits for some columns, but in others where the value is 10^-7 (or something like that), I can't.  For example, in the HT2diffId All column under mean, I just have number signs even though I changed the format to scientific.  What am I missing?

11320_pastedImage_0.png

11324_pastedImage_1.png

3 REPLIES 3
Enthusiastic
Level II

Re: Numeric Formats in Tabulate Platform

Hi @natalie_ 

 

I'm currently experiencing the same issue. One work-around I found was to format the column, I wanted to tabulate data from, into the format I wanted e.g.:

dt = Data Table(1);
dt:HT2diffId << format("Engineering");

and then create the tabulated data.

I tried "Scientific", but that did not seem to introduce the change I wanted. "Engineering" or "Engineering SI" worked to an extent though the control of significant digits is a little off.

Enthusiastic
Level II

Re: Numeric Formats in Tabulate Platform

I found something that works, but I don't know why. Here is my original code. I'm creating a bunch of Tabulate tables by looping over the elements in testDataColumns:

Tabulate(
			Title("Summary"),
			Show Control Panel(0),
			Add Table(
				Column Table(
					Statistics( Min, Max, Median, Mean, Std Dev),
					Analysis Columns (:column(dt,testDataColumns[i]))
				),
				Row Table(Grouping Columns(:Mode))
			),
			Set Format(
				Min ( (:column(dt,testDataColumns[i]))(15, 3)),
				Max ( (:column(dt,testDataColumns[i]))(15, 3)),
				Median ( (:column(dt,testDataColumns[i]))(15, 3)),
				Mean ( (:column(dt,testDataColumns[i]))(15, 3)),
				Std Dev ( (:column(dt,testDataColumns[i]))(15, 3))
			)
		)

This does not work. Format is complete ignored. However, if I do this:

abba = (:column(dt,testDataColumns[i]));
Tabulate(
			Title("Summary"),
			Show Control Panel(0),
			Add Table(
				Column Table(
					Statistics( Min, Max, Median, Mean, Std Dev),
					Analysis Columns (:column(dt,testDataColumns[i]))
				),
				Row Table(Grouping Columns(:Mode))
			),
			Set Format(
				Min ( abba(15, 3)),
				Max ( abba(15, 3)),
				Median ( abba(15, 3)),
				Mean ( abba(15, 3)),
				Std Dev ( abba(15, 3))
			)
		)

Format is correctly applied.

Just thought I'd add this in case anyone could use it.

txnelson
Super User

Re: Numeric Formats in Tabulate Platform

Try setting the columns in the data table you are using in the Tabulate to the format you want to be used in the final Tabulate table. The formats should be brought forward.
Jim