Format decimal in a List
Confluence User - 14 Oct, 2018
Halo,
I'd like to make my column in a format of 2 decimal.
Tried this script but blank, in General > Action Mapping > Formatter > Configure Bean Shell Formatter
import java.text.DecimalFormat;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.form.model.Element;
import org.joget.apps.form.model.FormData;
import org.joget.apps.form.model.FormRow;
import org.joget.apps.form.model.FormRowSet;
import org.joget.apps.form.model.FormStoreBinder;
import org.joget.plugin.base.PluginManager;
public FormRowSet store(Element element, FormRowSet rows, FormData formData) {
//format to 2 decimal
DecimalFormat df = new DecimalFormat("#.00");
row.setProperty("myvalue", df.format(myvalue));
}
return rows;
Hope anyone can help, Thank you ..
datalists