Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rounding number

noopurjain
8 - Asteroid

Hello,

I need help with rounding numbers. I have values in the input column that I need to convert to the corresponding values in the output column. I'm unsure which function to use.

 

Input                       Output
71.93999863 →       71.94
78.49799919 →        78.5

 

 

Thanks for your help!

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

Round function should work! Have you tried it yet?

alexnajm
17 - Castor
17 - Castor

Round([Value], 0.01)

nagakavyasri
12 - Quasar

@noopurjain Try round function with the data type as Float/Double

 

Screenshot 2024-11-06 120803.png

Labels
Top Solution Authors