Alteryx Designer Desktop Discussions

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

Need your help in number format

alt_tush
9 - Comet

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.

2 REPLIES 2
LordNeilLord
15 - Aurora
Hey @alt_tush

Try: floor([my column])

Neil
alt_tush
9 - Comet

Hey Neil,

 

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

Labels