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

Alteryx Designer Desktop Discussions

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

A decimal and two 0s (.00)

KaylReiter
7 - Meteor

What function and/or what do I need to write to get this column to have a decimal and two 0s on the end?

KaylReiter_0-1592330547994.png

They are of "Double" data type and I need them to stay that way because I'll need to add them up later.

 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @KaylReiter you would need to change your date type to a fixed decimal type set to "19.2" rather than double however you would still be able to add them later on.

KaylReiter
7 - Meteor

Thank you! I appreciate it.

Labels
Top Solution Authors