SOLVED
Negative Decimals
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
NBPSE
8 - Asteroid
‎08-28-2024
05:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Why are some of my decimals coming over as negatives, and how do I fix them to come over as 5 digit decimals?
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
4 REPLIES 4
cmcclellan
14 - Magnetar
‎08-28-2024
06:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't understand the screenshot, can you provide more information or explain what you're doing in the workflow please?
TUSHAR050392
11 - Bolide
‎08-28-2024
07:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NBPSE Are you referring to the exponential notation? Have you tried using Round function - round([Column Name], 0.00001) for 5 decimal place?
21 - Polaris
‎08-28-2024
11:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NBPSE
Maybe we can use the Select tool to change the data type to Fixed Decimal?
‎08-29-2024
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, Qiu! The Select tool fixed the issue.
