Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Comparison issue "Double = Double"

binuth
5 - Atom

Any Idea, why my first test "TestDouble_01" is failing?

 

Sample workflow attached.

Thanks!

 

Capture.PNG

2 REPLIES 2
j_acon
9 - Comet

try round it to the same decimal place 

 

[TAXPERUNIT] = Round(1.4,0.1)

 

 

 

 

I am not sure why this is the case, could be a bug.

 

I took your field and created a new field with 1.4, did a select and change them to fixed decimal  20.18 to check their precision

The value coming from your field end up being 1.400000000000000133

The one that was entered manually in a formula tool end up being 1.399999999999999911

 

 

 

 

binuth
5 - Atom

Interesting... !!!

Round will work for me. Thank you for your help!

Labels