Removal of Decimals Without rounding

[CCrawford94]

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!

[ivoller · Accepted solution]

FLOOR function or Regex tool could be used

[BenMoss · Accepted solution]

Sure, just wrap your field in FLOOR()

e.g. Floor([Field1])

Would change

2334.79

to

2334

Ben

[AMERINO]

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

[ChrisTX]

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)

Example

FLOOR(1.1) returns 1

FLOOR(6.54) returns 6

FLOOR(-30.42) returns -31