Using Configure Field Function in Reports - True/False

[StephenLambert]

Hello community,

I'm trying to create a report that lists how many INC were opened and resolved by the same person on the same day, without being reassigned or reopened.  This is how our company is gauging "First Call Resolved".  I'm currently comparing these fields in Excel and would like to move this to a report run purely in ServiceNow.

To start, I am trying to compare two values in a report:  Opened By (we've actually configured a 'First Assigned To' field) and Resolved By field.  Is it possible to output a True/False using a "Configure Function Field" in a report to make this happen?

[Ankur Bawiskar]

@StephenLambert 

check this link on how to do that.

Calculated True/False Flag in a Reporting Function Field 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[StephenLambert]

I have reviewed that link @Ankur Bawiskar, but it does not address my need of comparing two string fields and outputting a True/False if they are the same vs different.

Would you please review my screenshot and let me know how I can adjust to make this work?

[Ankur Bawiskar]

@StephenLambert 

the link I shared uses divide method

check this link and also check response from Jay in same thread

How to create a Function field with reports to generate True and False values? 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[StephenLambert]

Hello!   

Thank you so much for your direction thus far, @Ankur Bawiskar. I've tried a bunch of permutations of an equation to make this work, but none are successful. In the link you referenced, including the response from Jay, that seems to be a check of a field being populated or not.  What I am needing is a way to compare the contents of two fields on the Incident table to see if they are identical or not. (First Assigned To == Resolved By)

Is this feasible?