Page 1 of 1

Convert Cell 2 Decimal Places

Posted: Fri Jul 25, 2014 3:03 pm
by Nick Pitt

Hi

Please can you tell me this formula doesn't work. Im trying to get a percentage with 2 decimal places.

var a1 = parseFloat(Appery("AllData_Ave").text()), a2 = parseFloat(Appery("locdata_Ave").text());
Appery("VarAve");Math.round(a1/a2).toFixed(2);

Thanks


Convert Cell 2 Decimal Places

Posted: Fri Jul 25, 2014 5:42 pm
by Evgene Karachevtsev

Hello Nick,

Instead of
preAppery("VarAve");Math.round(a1/a2).toFixed(2); /pre
could you please try
preAppery("VarAve").text((a1/a2).toFixed(2));/pre