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
Theresa
Level IV

how to change one column to percentage format

Like change the weight column to persentage:

 

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

 

how to covert the "weight" column as  "95/100*100"=95%. 95% as the final result?

 

                        height  weight

KATIE small F    59    95
LOUISE small F 61 123

 

 

1 REPLY 1
txnelson
Super User

Re: how to change one column to percentage format

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
for each row(
     :weight = :weight / 100;
);
dt:weight << format("Percent",7,2);

Percent format uses 1 as 100%, and any decimal value less than 1 as the percent of 1.  Therefore .59 will be displayed as 59%

 

Jim