Different total from data and summarization tool

[maygross]

Hi,

I'm a little confused by alteryx today. I have data that I am summarizing by month. When I use the summarization tool, it tells me my sum is 77549.898949. But when I open up the data, filter for the current month I'm looking at, and click the header for the column I'm trying to summarize, it's giving me a different number, over a 10k difference. I'm thinking this could possibly be due to my data type but IDK. I also am unsure which number is the correct one. Please help me make sense of it. My data type is FixedDecimal, size 19.2.

[geraldo]

@maygross 

Yes, this type of data can make a difference in the result. It truncates probably giving a warning when executing the workflow.
I don't know if in a value as big as you are pointing out but leases can give differences

[maygross]

What data type should i use instead to get the accurate/same sum in the summarize tool and the data? I can limit my decimal point to 2 spaces if needed. 

[geraldo · Accepted solution]

@maygross 

Well, I had this problem with the double data coming from the database and being interpreted by alteryx as fixeddeicimal 19.2. I was missing the accuracy of the origin. In the database query I did a cast to varchar and alteryx the data coming from the database through the select tool or auto field it changed to double and I had no problems