Friday, January 20, 2012

ROUND Function

ROUND function in NAV, rounds the value of a numeric variable.

For Example: ROUND(1234.56789, 0.001, ‘>’) returns 1,234.568

NewNumber := ROUND(Number [, Precision] [, Direction])

You can give your own precision in this function.


For Example: ROUND(1234.56789,0.50,’=’) returns 1234.50 i.e. nearest 50


ROUND(1234.4956789,0.25,'<') returns 1,234.25