6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

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

How to Round Down

JBO
8 - Asteroid

I need to round down my data to whole numbers.

1.56 = 1

1.43 = 1

2.78 = 2

3.01 = 3

 

Any help much appreciated.

2 REPLIES 2
MarqueeCrew
19 - Altair
19 - Altair
FLOOR(x)
Returns largest integer less than or equal to (x)

OpenExample

FLOOR(1.1) returns 1
FLOOR(6.54) returns 6
FLOOR(-30.42) returns -31


Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
JBO
8 - Asteroid

Thank you so much! And thank you for getting back to me so quickly. You saved me from having to do a lot of extra work. Cheers!

Labels