Hi,
There are different modes to hide the decimal places:
1. Using the rounding operations. The plugin includes different rounding operations:
– The ROUND operation returns the nearest integer number:
ROUND(451388.8888888889) = 451389
– The FLOOR operation returns the previous integer number:
FLOOR(451388.8888888889) = 451388
– The CEIL operation returns the next integer number:
CEIL(451388.8888888889) = 451389
2. The integer division by 1:
(451388.8888888889/1)>>0 = 451388
and that’s all.
Thank you very much for using our plugin.
Hey codepeople,
Thanks for your solution!
And how can I round up a number of hundreds? Example: 451388.8888888889 to 451,400
Currently I use this code: prec((fieldname6*fieldname7/360),0)
Thanks for Your help!
Hi,
In this case you should use a simple mathematical’s trick, please, modifies the equation as follows:
(function(){
var v = fieldname6*fieldname7/360;
if( v > 1000 ) return ROUND(v/100)*100;
else return ROUND( V );
})()
For example; using your numbers:
ROUND(451388.8888888889/100)*100 = ROUND(4513.888888888889)*100 = 4514*100 = 451400
Best regards.
