community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to Round Down

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.

Alteryx Certified Partner
Alteryx Certified Partner
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.
Highlighted
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