Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Any formula for round down ?

Ewbkm
6 - Meteoroid

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.

2 REPLIES 2
Qiu
17 - Castor

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

Capture1F.PNG

Christina_H
11 - Bolide

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

Christina_Hurrell_0-1635323484466.png

 

Labels