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
20 - Arcturus
20 - Arcturus

@enkenmendoza 

A FixedDecimal might also do the work.

Capture11.PNG

enkenmendoza
7 - Meteor

thanks!

Labels