Hello guys,
I have a table cell that has a value of 0.000 as a result of a difference between two equal double values.
How can I query that table where cell_value=0 ? It doesn't return enithing.
Looks like int 0 is not equal with double 0.000. Is this a bug ?
Thank you.
Hi @michael.m11,
It's hard to know how to help without looking at your model. To receive a more accurate solution, please post your model or a sample model that demonstrates your question.
Proprietary models can be posted as a private question visible only to FlexSim U.S. support staff. You can also contact your local FlexSim distributor for phone or email help.
The difference might be zero at the first visible digits. How do you know the two floating values are the same? Have you subtracted A from A and compared it with zero. Floating point values near zero are a bit imprecise if it comes to be exact zero. Maybe you can query to a range near zero like with the clause BETWEEN value1 AND value2.
See also https://en.wikipedia.org/wiki/Floating-point_arithmetic#Accuracy_problems
If you set a floating point value (such as a double) directly to 0, then it will compare to 0 just fine. If a double is the result of a mathematical calculation, it is unlikely to be precisely 0 and you shouldn't compare it to 0 using equality.
Instead of comparing a double to 0, compare whether its absolute value is less than a very small number.
15 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
