Alteryx Designer Discussions

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

Round

Harsh14
8 - Asteroid

Hi in my Input the data contains the values

Input     

1253940.45

35000.0399

52836.9399

62066.2299

 

and I want ouput as 

1254

35

20

62

 

I have tried Round formula but it didnt showed up correctly.

2 REPLIES 2
atcodedog05
21 - Polaris

Hi @Harsh14 

 

You can do it with below config.

 

Workflow:

atcodedog05_0-1631527906597.png

 

Roud() actually rounds to the nearest thousand.

 

Hope this helps : )

Pingu
9 - Comet

Hi @Harsh14 

 

Use a formula tool and put: Round([YOURFIELDNAME]/1000,1)

 

(Heh, am i going crazy or where both posts above edited recently? And yes probably not even a round formula needed :))

Labels