Round

[Tid14]

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.

[atcodedog05]

Hi @Tid14 

You can do it with below config.

Workflow:

Roud() actually rounds to the nearest thousand.

Hope this helps : )

[Pingu]

Hi @Tid14 

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 :))