Rounding

[lindsayhupp]

Hi Everyone!

I'm having an issue where I am dealing with some very large monthly data sets.  Each month has roughly 500,000 lines in the data so I thought using alteryx to add the individually months together and pair the data down to only the info I need would be great.  However, when I run the data through alteryx I'm finding the data isn't being brought in properly.  One item I appear to have identified is that alteryx is rounding any number that is in the thousands to single digit whole numbers.  For instance, 6,993.15 in the data is being brought into alteryx as 6.  

Any help would be greatly appreciated! Thank you!

[alexnajm]

My guess is that you are using a select tool to try to change the column from a string to a number, but the comma that is in your values is cutting it off. Use a formula instead to remove the comma and convert to number.

[Qiu]

@lindsayhupp 
As @alexnajm mentioend, we need to perform some data cleansing for this format.

remove the "," with formula tool.

Btw, in alteryx, you can see the data with numeric seperator in the result window, but we can not bring the data directly into alteryx in numeric format for data with numeric seperator.

[caltang]

Another thing to consider could be your settings. Which region are you from? Commas and dots means different things in numeric sense. 

In German 99,99

In US 99.99 

Same thing.

So when it’s 6,399.15 and you’re getting 6, that looks like it’s taking in 6.39915 - rounding it down to 6. 

That’s something else to consider as well.

[caltang]

Refer here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Fieldtype-Number-with-Comma-as...

Decimal separators could’ve changed.