Any formula for round down ?

Question

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.

Qiu · Accepted Answer

@Ewbkm 
I think we can play with it as String then change it back to Numeric.

Christina_H · Accepted Answer

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