Round numbers to the nearest 100

[arieta]

Hello, I have multiple numeric columns in my workflow that I need to round, but I’m facing some issues on how to do this. My numeric data represent people, so I need to add a function that rounds the numbers to the nearest 100 people. Please see an example of how my data look. Thank you in advance for your help!

Type	Data1	Data2	Data3	Data4	Data5
Category 1	89539.5665746377	90675.5497225579	92657.87453739	95927.6758442895	98614.315437384
Category 1	89539.5665746377	90675.5497225579	92657.87453739	95927.6758442895	98614.315437384
Category 2	88350.0114811364	89725.1325384990	89995.1436095356	90189.36485950662	91342.7453429845

[ab3106694 · Accepted solution]

The ROUND formula should do it - here is a link to a helpful article: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Round-Numeric-Values-with-th...

Since you have multiple numeric columns you want to round, you could use a Multi Field formula tool, and the ROUND formula with a formula something like ROUND([_CurrentField_],100), selecting the numeric fields.