Floating point datatypes

[chris_love]

I've had some issues today with the double datatype and values that are rounded e.g. round([column],0.01) not matching when filtered e.g. [column1] == [column2], changing the datatype to Fixed Decimal fixed the issue obviously.

What is Alteryx's best practice recommendations around using Floating Point data types like Double, and when is the use of them likely to cause issues like the above?

Regards,

Chris

 

[Ned · Accepted solution]

There is an FAQ in the help:  http://help.alteryx.com/current/FAQ.htm#30

There are also 2 formula functions explicitly designed for comparing doubles: http://help.alteryx.com/current/Reference/Functions.htm#Test

[chris_love]

Perfect answer, just what I was looking for, thanks Ned.