Formula to get actual difference (AD), singlet and blank as last column using formula tool

Desaisid

Spoiler

Hi,

For 'Rate' and 'Rate 2', I wanted to compare and get a result in 'Fixed rate check test' column

Rate	Rate 2	Fixed rate check Test
2.78	1.02	AD
2.78	0.2	AD
2.78	0.2	AD
2.78	0.53	AD
	3.85	Singlet
0	1	AD
2.9000000000	2.9	AD
2.9300000000	2.93	AD
2.9300000000	2.93	AD
2.9300000000	2.93	AD
2.9300000000	2.93	AD
2.9300000000	2.93	AD
2.9300000000	2.93	AD
3.2100000000	3.21	AD
3.2100000000	3.21	AD
3.2550000000	3.255	AD
3.2800000000	3.28	AD
3.2800000000	3.28	AD

I'm using below formula

I wanted to get only those numbers where I see actual difference as AD, and I want below bold as blank.

Rate	Rate 2	Fixed rate check Test
2.78	1.02	AD
2.78	0.2	AD
2.78	0.2	AD
2.78	0.53	AD
	3.85	Singlet
0	1	AD
2.9000000000	2.9
2.9300000000	2.93
2.9300000000	2.93
2.9300000000	2.93
2.9300000000	2.93
2.9300000000	2.93
2.9300000000	2.93
3.2100000000	3.21
3.2100000000	3.21
3.2550000000	3.255
3.2800000000	3.28
3.2800000000	3.28

Clifford_Coon

Hi @Desaisid ,

It looks like your data types might not be the same, one appears to be a double and the other a fixed decimal.

that may help.

Actual they may be string fields, try making the same type as all double