Nick Pitt
Posts: 0
Joined: Tue Feb 18, 2014 12:44 pm

Convert Cell 2 Decimal Places

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

Evgene Karachevtsev
Posts: 12
Joined: Mon Apr 28, 2014 1:12 pm

Convert Cell 2 Decimal Places

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

Return to “Issues”