Round and Sum Problem

Hello @jpbenfica,

I’ve evaluated your equations manually and the result is correct:

PREC(fieldname2*(fieldname7+fieldname8)+(fieldname9+fieldname16),2) =
PREC(1*(2.2+1.5)+(0.34+0),2) =
PREC(3.7+0.34,2) = 
PREC(4.4,2) = 4.40

If you are referring to the fieldname9 field:

PREC((fieldname8*23.00*fieldname2)/100,2) =
PREC((1.5*23.00*1)/100,2) = 
PREC(0.345,2) = 0.34

You can evaluate it directly with the javascript method “toFixed” but the result is the same:

(0.345).toFixed(2) = 0.34

Best regards.

PREC(0.345,2) = 0.34

I need round 0.345 to 0.35

Hello @jpbenfica,

In this case, instead to use the “PREC” function, I recommend you to use the following mathematical operation:

ROUND(0.345*100)/100

Best regards.

For 1 item is ok. But for 2 items, same problem.

If enter in this page
2
20
20
0
Calculate

the Round is 8.09 when it was supposed to be 8.10

Hello,

I’ve checked your form again, but you have not edited the equations. Please, replace all calls to the PREC function with the mathematical operation I sent you in the previous entry.

Best regards.

this
PREC(((fieldname8*23.00*fieldname2)/100),2)

to

this
ROUND(((fieldname8*23.00*fieldname2)/100),2)

In this case, instead to use the “PREC” function, I recommend you to use the following mathematical operation:

ROUND(0.345*100)/100

But the fieldname8 is this

    (function(){
        if(fieldname4 <= 0) return '0.00';
        if(fieldname4 <= 100) return '1.50';
        if(fieldname4 <= 500) return '2.60';
        if(fieldname4 <= 1000) return '4.85';
        if(fieldname4 <= 2500) return '11.00';
    })();

Hello,

Not really, this operation:

PREC(((fieldname8*23.00*fieldname2)/100),2)

should transformed as:

ROUND((fieldname8*23.00*fieldname2/100)*100)/100

Best regards.

same problem

With
1 ok, 2 or 3 or 4 ERROR in Round
20
20
0

Hello,

I don’t know what form are you editing but you don’t have modified the equations in the form inserted on the webpage:

https://www.mundoemalerta.com/simulador-de-custos-para-envios-cobranca-ctt

Best regards.

Hello i have the same probleme
with this page https://www.a3com.fr/simulationtarifaire/?TempOp=90&NbApp=300&TVA=20
*
when i excute my link in Internet Explorer it word corectly
but when i use Google Chrome i have a different result
I used Prec function and i flow your solution about mathematic function( Round(x*100)/100 and still wrong result

I use this

ROUND(fieldnameX*23.00)/100;

The field Tax in my site

(function(){

if(fieldname23 > 0) return ROUND(fieldname23*23.00)/100;

if(fieldname25 > 0) return ROUND(fieldname25*23.00)/100;

})();

Hello @jpbenfica,

Thank you very much for sharing your solution, and yes, it is perfect.

Best regards.