Round to 5 decimal places

[Paddi]

Hi all,

I'm currently working on an issue to round the data to 5 decimal places. It is simple in excel, but I'm wondering how can it be done by alteryx.

The sample data has been attached. 

Thank you so much.

[gautiergodard]

hey @Paddi 

you can use the formula below. 

Round(Round([YOUR NUMBER FIELD], .000001),.00001)

Please accept as solution if this worked for you!

Hope this helps! 

[Raj]

hi 

you can use Round(ToNumber([number]),.00001) 

hope this helps 

please marked solved

[KrishnaChithrathil]

@Paddi 

[ShankerV]

Hi @Paddi 

Please find my solution below.

If I understand your requirement exactly, where you need to round of to 5 decimal places.

Especially 2.682103 need to be round for 2.68210

If you use just Round([Field1], .00001) will give the output as 2.6821 and not 2.68210 which you are expecting.

So one step in additional implanted to get your expected solution.

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[ShankerV]

Hi @Paddi 

My workflow:

Step 1: Input

Step 2: Formula tool

Output as expected like 2.68210

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[Fangfang]

Hi , this is Paddi's coworker,  may i ask you to test 4.655665? it should be round to 4.65567, but failed by whichever solutions. Hope to know the reason. 

[DataNath]

@Fangfang @Paddi the following gets you to your expected outcome:

Round([Input], 0.000010)

[ShankerV]

Hi @Paddi @Fangfang 

Please find the solution for your latest issue posted.

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V

[ShankerV]

Hi @Paddi @Fangfang 

Step 1: Input

Step 2: Regex tool

Step 3: Formula tool

Round(tonumber([Field1]), .00001)

PadRight(tostring([Out1]),7,'0')

if([RegExOut1]='5')
then tonumber([Out1])+0.00001
else [Out1]
endif

Output:

Kindly accept this solution if it provided a solution to your question.

Many thanks

Shanker V