Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to show a zero which is NOT a default value ?
Messen
Member Posts: 4
In a table I have a decimal field. Default value is by system zero. I would like this field to be blank, because we use this field as a result e.g. 0.00. But the default zero is not a result for us. So we will only like to see the zero when we have entered the zero by ourselfes and not the default.
Can anyone help ?
Can anyone help ?
0
Comments
So you could better use the BlankNumbers-property with the value BlankNeg and make sure your default value is eg. -1. This is only possible of course if all your results are >= 0.
Tx for your prompt reply. And yes - your solution was also my first workaround, but off course the users need to enter neg. figures :roll: Any other solutions ?
What about Additional (boolean) field "Manually Entered". FALSE by default and on validate of your numeric field you can set it to TRUE.
When displaying numeric filed you refer to this boolean field in OnFormat trigger of numeric field control...
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Sorry for my late answer...
TX for your answer. I will try your sultion with the Boolean filed. Have heard from secondhand that this is the best solution for my "problem". Thank you :-)