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

Removal of Decimals Without rounding

Highlighted
Meteor

Is there a way to remove decimal places without rounding the number?

 

For example: 64573.74 is the number but i would only want to see 64573.

 

If this is possible please elt me know the work around.

 

Thanks!

Quasar

FLOOR function or Regex tool could be used

Alteryx Certified Partner
Alteryx Certified Partner

Sure, just wrap your field in FLOOR()

 

e.g. Floor([Field1])

 

Would change

 

2334.79

 

to

 

2334

 

Ben

Meteoroid

It doesn't work for me... someone can help me?

 

 

Bolide

Your number is negative, so the next integer "less than or equal to -214.8" is -215

 

If your data includes negative numbers, try this formula:

 

IF [Importe total] >=0 THEN FLOOR([Importe total]) ELSE CEIL([Importe total]) ENDIF

 

Here is the documentation for all Functions:

https://help.alteryx.com/current/Reference/Functions.htm

 

FLOOR(x): Returns largest integer less than or equal to (x)

Labels