2 Decimal Places without Rounding

[fikrizahari]

Hi,

Good day !

I would like to 'round down' numbers to 2 decimal places.
Example as below :

Field1	Correct Output
30689.71	30689.71
4300.286	4300.28
6504.661	6504.66
6074.728	6074.72
467.1111	467.11
2222.249	2222.24
2277.22	2277.22
2273.7	2273.7
2277.22	2277.22

However, i could not find 'round down' formula in Alteryx, so I use 'floor' formula.
Formula for 'Round Down' column that i used, and the result as below :

You can see there some different expected output on Round Down column ( Record 7 - 9 ).
Please advise what is the reason, or is there any better formula to get 2 decimal places without rounding it.

Thanks !

[Yoshiro_Fujimori]

@fikrizahari ,

As you see the explanation of the function

If you input "0.05" as "mult" parameter, the function will find the "nearest multiple of 0.05".

So the nearest multiple of 1.21 would be 1.2, not 1.25.

In this case, you would need to shift the border by 0.025 (half of 0.05).

And also you need to shift a little bit to avoid the base conversion error.

With the formla below, 

Round([Field1] + 0.0249, 0.05)

The output would be

[reeteshchoudhury]

Hi, There is a very simple way to achieve this without any complex formula: Just use the floor function with the following parameter:

floor([Data],0.01)

Data               Result
1555.848      1555.84
3441.202      3441.2
6115.357       6115.35
2411.07        2411.07
60128.39      60128.39