how do I compare 2 fields in a table?

[marius1986]

Hi all
I am having a problem with a call by call report. I am trying to compare 2 fields , one with text and one with string but I don't know how. I've tried to convert the text into string using the val function but it returns 0. This is my case: "INTERCALL_ID: 57824301 DEST" is the associated data and the 57824301 is the call ID field.
I've tried the formula:
if val(mid({eCallByCallStatYYYYMMDD.AssociatedData},15,8))={eCallByCallStatYYYYMMDD.CallID} then {CallByCallStatYYYYMMDD.Source}
Is it correct or it easier to convert the string to text?

Thanks a lot!

 

[lbass]

You can do this with a variable, but you didn't address the issues I mentioned in my last post.

-LB

 

[marius1986]

Events in the Call by Call Statistics report are grouped by call ID. Each call event has his unique ID .