Hi
I need to round down all my data to 4 digits. In Excel, the formula is rounddown (value, 4)
This is the results I expect in
Original Data >> Expected rounddown results
1.55567 >> 1.5556
1.55533 >> 1.5553
200.38949>> 200.3894
35.79999999999>> 35.7999
Is there any formula or function in Alteryx I can use for this rounding down?
Thanks.
Solved! Go to Solution.
@Ewbkm
I think we can play with it as String then change it back to Numeric.
As an alternative, the equivalent function to rounddown is Floor. You can't specify a number of digits, it rounds to the nearest integer, but it's easy to get around that:
FLOOR([Number]*10000)/10000