Different total from data and summarization tool

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.

Datasets

Developer

Developer Tools

In Database

Data Investigation

In-Database

Accepted answers

geraldo

@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

All comments

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

@maygross

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703