Possible Rounding issue in NAV
jordi79
Member Posts: 281
Hi,
Code to perform a rounding as as follows:
Dec1 := 14.32455;
Precision := 0.01;
MESSAGE(FORMAT(ROUND(Dec1, Precision, '=')));
Once code is executed, the result is: 14.32
I would have expected the output to be 14.33. Is my assumption correct? This code is executed in NAV ver 5Sp1. The same result is observed in ver NAV 3.10.
Code to perform a rounding as as follows:
Dec1 := 14.32455;
Precision := 0.01;
MESSAGE(FORMAT(ROUND(Dec1, Precision, '=')));
Once code is executed, the result is: 14.32
I would have expected the output to be 14.33. Is my assumption correct? This code is executed in NAV ver 5Sp1. The same result is observed in ver NAV 3.10.
0
Comments
-
no, the result is mathematically correct, if you round to the second dec, you have to take into account only the third decimal. example:
2,444444444444444444445 rounded to the second dec is 2,44
0 -
Hi Belias,
You are correct. The result IS mathematically correct. What was I thinking! Must be all the hours spent staring at the computer have fried my brains.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 322 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions