IF Statement in Alteryx is working for some of my data

[Ash1293]

Hi,

I have an Alteryx module which i have created and i have added this Formula in saying:

'IF [Trade Price]-[TRADE 1]=0
Then 'Yes'
Else 'No'
ENDIF'

I have attached the first 10 rows which should that the two columns are matching but Alteryx is showing a Else result.

I know that out of 129,000 Records the formula is working for 74,000 records but there are 54,000 records which are showing as No but in there are records that should say yes

[Ash1293]

I saw this and i used the ROUND formula to by pass this. Is it better to use Fixed decimal??

[Ash1293]

Hi @atcodedog05,

I have now tried the fixed decimal format and removed the rounding formulas but it is still giving me the same issue where the numbers are not being marked as a match