In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Negative Decimals

NBPSE
8 - Asteroid

Why are some of my decimals coming over as negatives, and how do I fix them to come over as 5 digit decimals?

4 REPLIES 4
cmcclellan
14 - Magnetar

I don't understand the screenshot, can you provide more information or explain what you're doing in the workflow please?

TUSHAR050392
11 - Bolide

@NBPSE Are you referring to the exponential notation? Have you tried using Round function - round([Column Name], 0.00001) for 5 decimal place?

Qiu
21 - Polaris
21 - Polaris

@NBPSE 
Maybe we can use the Select tool to change the data type to Fixed Decimal?

0829-NBPSE.png

NBPSE
8 - Asteroid

Thank you, Qiu! The Select tool fixed the issue.

Labels
Top Solution Authors