community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Need your help in number format

Asteroid

Hi Team,

 

I have a below numbers in a column

 

My Column               Expected Output

 

123                           123

687.123                    687

150.000                    150

018.678                    18

0.879                        0

175.975                    175

 

Could you please help me which formula should I refer to get expected output.

 

Thank you in advance.

Alteryx Certified Partner
Hey @alt_tush

Try: floor([my column])

Neil
Highlighted
Asteroid

Hey Neil,

 

Thank you so much for your as usual help. :)

Labels