Hello everyone,
I have a question about the rounding results.
Why does rounding to 3 decimal places on the value 0.3301 give only 0.33 and not 0.330?
Thank you in advance for your help.
Ludivine
Find maintenance, best practice, and troubleshooting articles.
Hello everyone,
I have a question about the rounding results.
Why does rounding to 3 decimal places on the value 0.3301 give only 0.33 and not 0.330?
Thank you in advance for your help.
Ludivine
Instead of round(x,y) use formatnumber(x,y) or formatnumber(x,y,true,true,false) It will give you the results as you want, but they will be in String format, not numeric, so further calculation won't be easy :)
Instead of round(x,y) use formatnumber(x,y) or formatnumber(x,y,true,true,false) It will give you the results as you want, but they will be in String format, not numeric, so further calculation won't be easy :)