We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

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