Message Tool Following Summarize Tool Unexpected Results

I've attached a workflow that summarizes some input data and then provides an error message if the summarized data doesn't sum to 100. I've output the summaries to excel and validated that each row is indeed 100 by the function (=cell=100) which correctly outputs "true". However in Alteryx it seems to be flagging rows as not equaling 100. Please advise. Sample workflow attached with sample data. Running it on my system results in:

test.yxmd

Workflow

Accepted answers

AngelosPachis

@SaleemB another way to confirm what I explained above is with a formula tool and an if statement

as you can see, only one record is exactly equal to 100

All comments

AngelosPachis

Hi @SaleemB ,

I believe that has to do with your data type, or better it might be a rounding issue. The values appearing in your screen might seem like they are 100, but since the data type is of double precision and based on how computers store numbers, the actual value is more like 99.999...99996 or something similar.

One option is to add a select tool and convert the data type to Integer. Another option is to use a formula tool to round to the nearest decimal or integer. Both should work

test_v2.yxmd

AngelosPachis

@SaleemB another way to confirm what I explained above is with a formula tool and an if statement

as you can see, only one record is exactly equal to 100

SaleemB

Thanks....this makes sense!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703