Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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