Summarize Tool rounding issue

Hi all,

I have a sample workflow that looks something like this:

In the join tool, all records from the input tool goes to the Left output anchor.

When i summarize the amounts, the summary tools result in slightly different values (probably due to rounding).

The top summarize tool returns a value of 1987762.86140003 (which is correct), while the bottom summarize tool returns the value 1987762.8614001.

Does anyone know why this happens and how I can ensure that both summarize tools result in the same values?

Attached is the sample workflow.

New Workflow3.yxzp

Common Use Cases

Accepted answers

flying008

Hi, @gjunhao96

This is the precision error caused by floating point operations.
Because of the approximate nature of the float and real data types, do not use these data types when exact numeric behavior is required, such as in financial applications, in operations involving rounding, or in equality checks.
The correct result should be 1987762.8614, so you can format the number type to FixedDecimal and size like 19.4 first if you want.

All comments

grazitti_sapna

@gjunhao96 , In my case its showing same values for both. Can you help in replicating your issue. Or may be you are using old version of alteryx.

gjunhao96

@grazitti_sapna The display is similar as it is rounded to 4 dp. But when you double click on the values, there are small variances.

flying008

Hi, @gjunhao96

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703