Changin the signs of a number in reports
sabzam
Member Posts: 1,149
Dear All,
I must admint that this is a very simple question but I can't find an answer to it. How do I make a number look negative when positive or vice-versa in a report?
I must admint that this is a very simple question but I can't find an answer to it. How do I make a number look negative when positive or vice-versa in a report?
0
Comments
-
You can stick a negative (-) sign in front of it (I think it works on variables). If not you can multiply it by -1.0
-
For some reason which I simply can't understand mutiplying it by -1 results in a zero. Can it be that I have a property which I don't know about?
I understand that this is a very simple question but I simply can't find a solution to it. Usually just through multiplication it works perfectly but this time it is zeroing the number0 -
Perhaps you could post your code. Maybe just a simple syntax mistake. I know I've done it enough times.0
-
I have just solved it by simply mutiplying it in the pre-section of the section. Thanks for your help0
-
the normal place to do such action is in the onaftergetrecord trigger. This trigger is runned, after the data is catched from the table, but before it is shown in the form.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
