We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.

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