Dollar sign ($) in text box format rounds decimals?

AlexWiley
Member Posts: 230
I searched for awhile and could not find a similar post. I'm trying to add a dollar sign to the total amount of an invoice. In the source expression I have:
TempSalesInvoiceLine."Amount Including VAT"
and the amount appears correctly as "92.20". However, when I add:
'$' + FORMAT(TempSalesInvoiceLine."Amount Including VAT")
It displays "92.2". It is also making the value show up with Left horizontal orientation, despite being set at Right. When I add the '<Precision,2:2><Standard Format,0>' before the source information it gives me an Overflow error on the 92.2 value. I could work around it by putting a '$' label in front of the textbox, but I would like something cleaner if possible.
TempSalesInvoiceLine."Amount Including VAT"
and the amount appears correctly as "92.20". However, when I add:
'$' + FORMAT(TempSalesInvoiceLine."Amount Including VAT")
It displays "92.2". It is also making the value show up with Left horizontal orientation, despite being set at Right. When I add the '<Precision,2:2><Standard Format,0>' before the source information it gives me an Overflow error on the 92.2 value. I could work around it by putting a '$' label in front of the textbox, but I would like something cleaner if possible.
0
Answers
-
you could always try:
strsubstno('$%1',TempSalesInvoiceLine."Amount Including VAT")
--scrap that--didnt read about the decimals properly0 -
Go to the textbox properties and on the format property write :
$<Sign><Integer Thousand><Decimals,3>0 -
You're welcome.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