Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Arrow up icon
GO TO TOP
Programming Microsoft Dynamics NAV

You're reading from   Programming Microsoft Dynamics NAV Hone your skills and increase your productivity when programming in Microsoft Dynamics NAV 2017

Arrow left icon
Product type Paperback
Published in Apr 2017
Publisher Packt
ISBN-13 9781786468192
Length 706 pages
Edition 5th Edition
Languages
Arrow right icon
Authors (3):
Arrow left icon
Marije Brummel Marije Brummel
Author Profile Icon Marije Brummel
Marije Brummel
David Studebaker David Studebaker
Author Profile Icon David Studebaker
David Studebaker
Christopher D. Studebaker Christopher D. Studebaker
Author Profile Icon Christopher D. Studebaker
Christopher D. Studebaker
Arrow right icon
View More author details
Toc

Table of Contents (18) Chapters Close

Title Page
Credits
Foreword
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Customer Feedback
Acknowledgments
1. Introduction to NAV 2017 FREE CHAPTER 2. Tables 3. Data Types and Fields 4. Pages - the Interactive Interface 5. Queries and Reports 6. Introduction to C/SIDE and C/AL 7. Intermediate C/AL 8. Advanced NAV Development Tools 9. Successful Conclusions

Data conversion and formatting functions


Some data type conversions are handled in the normal process flow by NAV without any particular attention on part of the Developer, such as Code to Text and Char to Text. Some data type conversions can only be handled through C/AL functions. Formatting is included because it can also include a data type conversion. Rounding does not do a data type conversion, but it does result in a change in format (the number of decimal places). Let's review the following functions:

  • The ROUND function
  • The FORMAT function
  • The EVALUATE function

ROUND function

The ROUND function allows us to control the rounding precision for a decimal expression. The syntax for the ROUND function is as follows:

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

Here, Number is rounded, Precision spells out the number of digits of decimal precision, and Direction indicates whether to round up, round down, or round to the nearest number. Some examples of Precision values follow:

If...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime
Visually different images