Round function

jigarvyas_1
jigarvyas_1 Member Posts: 8
edited 2008-11-14 in NAV/Navision Classic Client
Dear All,
I am not able to understand the round off function concept.
Suppose if the number is 1234.56789, precision=100 and direction '=',then what will be the round off of this value? kindly explain the answer also.

Thanks and regards,
Jigar Vyas

Comments

  • garak
    garak Member Posts: 3,263 
    dec := 1234.56789;

message(format(round(dec,100,'=')));

    The first operator of function round is the deciaml variable, the second say in which steps he should round, here ever 100, the 3-rd mean how to round. here nearest value.
    So in your case 1234.56789 (if the . is a commata and after the . the numbers are decimal places) the result is 1200. Because round to 100 and = (to the nearest) 34 < 50 -> round down.

    If 123456789 is the decimal value without decimal places, the result is 123456800 (89 > 50 -> round up to the next 100).

    A little tip. For more informations open a nav object in design mode. Press now F5. The C/AL Symbol Menu is opened. On the Left side go to SYSTEM. in the middle to Numeric and on the right to Round. If round is "BLue" press F1. There is also a good help.

    Regards
    Do you make it right, it works too!
  • DaveT
    DaveT Member Posts: 1,039
    garak wrote:
    A little tip. For more informations open a nav object in design mode. Press now F5. The C/AL Symbol Menu is opened. On the Left side go to SYSTEM. in the middle to Numeric and on the right to Round. If round is "BLue" press F1. There is also a good help.

    =D> Fantastic Tip - Thanks saves a lot of clicking :mrgreen:
    Dave Treanor

    Dynamics Nav Add-ons
    http://www.simplydynamics.ie/Addons.html

Categories