About Round function

navuser1

Dear All,

Please share your knowledge.
How precision in round function works in Navision?

If precision=0.123, then how round function will work?

DaveT

Hi,

The round function is different (but cool) from most other programming languages. It will round to the nearest of the value sent in the argument ( 0.123 in yor case ) so if you send 1 to round to 0.123 you will get 0.984 i.e. 0.123 * 8

navuser1

Thanks,

Please tell me the logic.

NewNo=round(Number,Precision,Direction)
if Number=1.123, Precision=0.11, Direction='>', then NewNo=?

DaveT

Hi,

It divides 1.123 by 0.11 = 10.20909

With no direction rounds to 10 * 0.11 = 1.1

with direction rounds to 11 * 0.11 = 1.21 i.e. round up to the next multiple of 0.11

navuser1

Great!
Thank you very much for your reply.

DaveT

Gald to help

IvonaK

Hi to all,

How I can round number:1.5 to 2 and number:1.6 to 2.

I tried with

ROUND(ROUND(1.5,1.001,'='),1)

it works for number 1.6 but it doesn't work for number 1.5.

Thanks a lot,

mohana_cse06

What do you want to do with 1.4 or 1.3?
If you want to make it to 2 then you use > instead of = in your expression..

Help on Round function is here
http://msdn.microsoft.com/en-us/library/dd301418.aspx

IvonaK

I would like to round decimal number to integer so if floating part is >= the 0.5 to round up to the nearest value
for example if I have number

122.30 I would like to round to 122.00
122.50 I would like to round to 123.00

I tried with ROUND(DecimalNumber,1,'=');
and It works.

Thank a lot