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

[binuacs]

@Desaisid One way of doing this

[cjaneczko]

Adding a select tool to your workflow and changing the Rate and Rate 2 to Double will let your formula work correctly. 

[Desaisid]

After changing it to Double what data type I should keep for 'Fixed rate check test'

[Desaisid]

I have 94 different formulas which I have to change if I change this 1, Can you help me with my current formula as how can I change in this one. Like what data type should I use for all 3 columns

[binuacs]

@Desaisid Rate1 and Rate2 should be double and result should be string type

[Desaisid]

I have put Double in both rates and Result in string type it is showing me error

[binuacs]

@Desaisid Can you screen shot the metadata in your formula tool