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!
Solved! Go to Solution.
FLOOR function or Regex tool could be used
Sure, just wrap your field in FLOOR()
e.g. Floor([Field1])
Would change
2334.79
to
2334
Ben
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)
FLOOR(1.1) returns 1
FLOOR(6.54) returns 6
FLOOR(-30.42) returns -31