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

1 comment:

  1. here is a little more detailed:
    http://msdn.microsoft.com/en-us/library/dd301418.aspx

    ReplyDelete