Accounts Schedule - Rounding issue

victoria
Member Posts: 16
Dear all,
In Accounts Schedule (report ID 25), all figures are displayed with 2 decimal places. Is there a way to change rounding - to round to whole figures (no decimals at all)? E.g. instead of 1255.23 to display 1255, etc.
Thanks for your help.
In Accounts Schedule (report ID 25), all figures are displayed with 2 decimal places. Is there a way to change rounding - to round to whole figures (no decimals at all)? E.g. instead of 1255.23 to display 1255, etc.
Thanks for your help.
0
Comments
-
First I must state that I'm not familiar with this report so I don't know what it does.
In general I can think of two ways of controling rounding.
1. You can call a rounding function before displaying the value:
NewNumber := ROUND(Number [, Precision] [, Direction])
2. You can edit the "Format" property of the control that's used to display the value. Entering "<Sign><Integer>" should give you the result you want. Select the format property ant hit F1 to get help on how to construct format strings.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
- 320 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