.svg){kind=icon}
.gif)
.svg)
- Inside Alteryx's workflow designer, head over to the left-hand panel and find 'Formula'. Drag it onto the canvas and connect it to the Input Data tool or other sources.
- After that, go to the right-hand panel and configure the selected tool. To get started, enter your preferred Output Column name into the provided field and specify the Field Type you wish to set.
- Subsequently, go to the Formula field and then type 'Round'. Select it from the suggested results.
- Replace X with '[' and then choose the field that contains the data you want to edit.
- Next, replace Mult with '0.01' to specify your desired multiplier, which is two decimal places.
- Finally, the data from the selected field in your Alteryx workflow will be rounded to 2 decimal places.
How to Round Numbers to 2 Decimal Places in Alteryx
Use this interactive demo to learn how to round numbers to 2 decimal places in Alteryx.
📌 Why this matters
Rounding to 2 decimal places transforms messy calculations into clean, presentable financial data that stakeholders can actually read and trust. When you're working with currency, percentages, or measurements, precise decimal control prevents embarrassing errors in reports and ensures consistency across teams. The real benefit emerges when you're preparing data for external consumption - whether that's client dashboards, regulatory filings, or executive presentations. Clean decimal formatting signals professionalism and attention to detail, while also making your datasets compatible with systems that expect standardized numeric formats.
Your product deserves an interactive demo
Similar Articles
No items found.