Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Need your help in number format

Highlighted
8 - 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.

Highlighted
Alteryx Certified Partner
Hey @alt_tush

Try: floor([my column])

Neil
Highlighted
8 - Asteroid

Hey Neil,

 

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

Labels