values mismatch

[akumar]

i have issue where i am comparing values from 2 fields which will have same value always, but sometimes it differs. I want to compare between these two feilds and have  status as Match or Mismatch. I have having issues where even if both fields have some value its showing as mismatch in status. 

| eval CheckMatch = if(f1==f2,"Match", "Mismatch")

Below is the sample result 

f1                       f2               CheckMatch
14552.06   14552.06    Mismatch

[ITWhisperer]

Are the fields of the same type, e.g. both numeric or both strings? Is either one a multivalue field?

[akumar]

Both are numeric values only. But before applying this match condition I am adding 2 field of values to F1 ( f1=a+b). 

[ITWhisperer]

Is there any rounding going on in the way the numbers are presented? Is it worth trying 

| eval CheckMatch = if(round(f1,2)==round(f2,2),"Match", "Mismatch")

[akumar]

I tried using your above command, now it’s matching all fields even if the values are not the same. 

[ITWhisperer]

Are they being treated as strings? What do you get with

| eval f1number=tonumber(f1)
| eval f2number=tonumber(f2)

[akumar]

please see below is the search I am using and the result set

 

3761C37E-6D09-45C3-A542-FBD62BFC5777.jpeg