Rounding a value just like a ROUND(Value;-3) in Excel

[Cfdiaz2103]

Hi guys!

Does anyone know how I could apply the Excel formula ROUND(Value;-3) into Alteryx Designer?

Here's a sample of the data I need to transform, and the result:

234342745 -> 234343000

3155 -> 3000

727860 -> 728000

1420168 -> 1420000

18197 -> 18000

I'd appreciate any kind of support.

[atcodedog05 · Accepted solution]

Hi @Cfdiaz2103 

Use round() function like below

Round([Field1], 1000)

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @Cfdiaz2103 

Cheers and have a nice day!

[Cfdiaz2103]

Hi @atcodedog05 !

Yes. It perfectly works.

Thanks in advance 😁