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

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