Round funcion
4 followers6 comments

Will Benica
Hi Amin,
I think what you really want is a floor or the rounddown functions. Both round a number down, the second argument is the number of digits after the decimal.
There's also the ceiling and the roundup function. similar to the above functions.
If you want to just have a normal round (return the nearest integer) there's the ROUND. This function however doesn't allow you to choose the number of places after the decimal point.
Please sign in to leave a comment.
Hi Amin,
Did you try the TRUNC function to truncate the decimals?