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:
Solved! Go to Solution.
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
@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
Thanks....this makes sense!