Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

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.

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