Rounding number

[noopurjain]

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!

[alexnajm]

Round function should work! Have you tried it yet?

[alexnajm · Accepted solution]

Round([Value], 0.01)

[nagakavyasri · Accepted solution]

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

[WesHarden]

This is weird.  I did the rounding function. When I summed the data following, the rounding did not work in the sum.  However, when I joined the field using a join, it recognized the rounding in the join and accepted the fields as matching (even though 100k records have miniscule fractions of a penny difference) example 12.4999998 to 12.5000002.  FYI, I am comparing data output from alteryx to a previous data source exported to excel.