topic how to change one column to percentage format in Discussions

how to change one column to percentage format

Theresa — Mon, 23 Mar 2020 02:14:11 GMT

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

txnelson — Mon, 23 Mar 2020 02:47:24 GMT

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%