Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

HOW TO ROUND OFF DECIMAL PLACES INTO TWO

enkenmendoza
7 - Meteor

Hi i have numbers here that I want to there are more than 2 decimal places. I just want to know if how to trim it into two.

 

Here is may data:

 

Amount:

-5180396.93000001
-1861843.78
242493316.969992

 

Expected output:

-5180396.93
-1861843.78
242493316.97

 

 

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@enkenmendoza,

 

Please see below how you can do it:

 

messi007_0-1616399261728.png

Attached the workflow,

 

If this solve your need, please mark it as solved it will help others.

 

Regards,

Qiu
21 - Polaris
21 - Polaris

@enkenmendoza 

A FixedDecimal might also do the work.

Capture11.PNG

enkenmendoza
7 - Meteor

thanks!

Labels
Top Solution Authors